Display Publication and Article Subscription Information

To display information about a publication subscription and article subscriptions, use the rs_helppubsub stored procedure at either the primary or replicate Replication Server RSSD.

For example:

To list all publication subscriptions at a site, enter:
```
rs_helppubsub
```
For each publication subscription known to the site, the display includes the names of the subscription and its associated publication, the names of the primary and replicate databases and data servers, status information, and the date of the latest change to the publication subscription.
To display information about a particular publication subscription, enter:
```
rs_helppubsub subscription_name
```
The output displays the information described in the above example for all publication subscriptions named subscription_name.
To display information about a particular publication subscription and its article subscriptions, enter:
```
rs_helppub subscription_name, publication_name, 
    primary_dataserver, primary_db, 
    replicate_dataserver, replicate_db
```
The output displays the information described in the above examples for all publication subscriptions named subscription_name. For each article subscription, the output displays subscription and article name, status information for the primary and replicate Replication Servers, replication definition name, autocorrection status, and the date of the latest change to the article subscription.

See the Replication Server Reference Manual > RSSD Stored Procedures > rs_helppubsub for complete syntax and usage guidelines, and sample output.