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 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 publications, use sp_helppub without specifying a publication.
To get metadata information about all subscriptions, use sp_helpsub without specifying a subscription.
