SQL Guide : System stored procedures : System stored procedures for advanced replication : SYNC_SHOW_REPLICA_SUBSCRIPTIONS
  
SYNC_SHOW_REPLICA_SUBSCRIPTIONS
The SYNC_SHOW_REPLICA_SUBSCRIPTIONS system stored procedure shows which subscriptions (publication name and parameters as string representation) of a publication are active in a specified replica database.
CALL SYNC_SHOW_REPLICA_SUBSCRIPTIONS (
  replica_name, -- WVARCHAR
  publication_name     -- WVARCHAR
)
EXECUTES ON: master.
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.
If the publication name is NULL, then subscriptions to all publications are listed.
The resultset of this procedure call is:
Column Name
Data Type
Description
REPLICA_NAME
WVARCHAR
Replica name.
SUBSCRIPTION
WVARCHAR
Publication name and parameters as a string
SUBSCRIPTION_TIME
TIMESTAMP
Time of last subscription.
SYNC_SHOW_REPLICA_SUBSCRIPTIONS error codes
RC
Text
Description
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_SUBSCRIPTIONS
See also
System stored procedures for advanced replication