SQL Guide : System stored procedures : System stored procedures for advanced replication : SYNC_SHOW_SUBSCRIPTIONS
  
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
See also
System stored procedures for advanced replication