SYNC_SHOW_SUBSCRIPTIONS

SQL Guide : System stored procedures : System stored procedures for advanced replication : SYNC_SHOW_SUBSCRIPTIONS

The SYNC_SHOW_SUBSCRIPTIONS system stored procedure shows which subscriptions (publication name and parameters as string representation) of a publication are active in a master database.

CALL SYNC_SHOW_SUBSCRIPTIONS (
publication_name -- WVARCHAR
)

EXECUTES ON: replica.

You must have administrator or synchronization administrator access rights to execute this stored procedure.

Tip: Same functionality is available in both master and replica catalogs. Use SYNC_SHOW_SUBSCRIPTIONS in the replica catalog and SYNC_SHOW_REPLICA_SUBSCRIPTIONS in the master catalog.

The result set of this procedure call is:

Column name	Data type	Description
SUBSCRIPTION	WVARCHAR	Publication name and parameters as a string
SUBSCRIPTION_TIME	TIMESTAMP	Time of last subscription.
13047	No privilege for operation
13133	Not a valid license for this product.
25009	Replica not found.
25010	Publication not found
25019	Database is not a replica database
25020	Database is not a master database.
25023	Replica not registered.
25071	Not registered to publication.

Related reference

SYNC_SHOW_REPLICA_SUBSCRIPTIONS