Getting metadata and status information for publications and subscriptions

Metadata and status information about publications and subscriptions includes:

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.