You can get metadata information about publications and subscriptions, and status and statistics information about subscriptions with the following procedures:
sp_helppub – returns metadata information about publications
sp_helpsub – returns metadata and status information about subscriptions
