Metadata and status information about publications and subscriptions includes:
Database server name and database name (ds.db)
Publication or subscription name
Publication name for subscription (subscriptions only)
Subscription status and status description (subscriptions only)
To get metadata information about a publication
Use sp_helppub with the info keyword, and specify the publication name:
sp_helppub info, pub_name
where pub_name is the name of the publication.
To get metadata information about all publications
Use sp_helppub without specifying a publication:
sp_helppub
To get metadata and status information about a
subscription
Use sp_helpsub with the info keyword, and specify the subscription name:
sp_helpsub info, sub_name
where sub_name is the name of the subscription.
To get metadata information about all subscriptions
Use sp_helpsub without specifying a subscription:
sp_helpsub
