Display Publication and Article Information

Use the rs_helppub stored procedure at either the primary or replicate Replication Server RSSD to display information about a publication and its articles.

Note: Although you can execute rs_helppub at the primary or replicate site, rs_helppub only displays publication information stored at the site at which it is executed. For example, if you execute rs_helppub at the primary site, rs_helppub displays information about all publications created at that site. If, however, you execute rs_helppub at the replicate site, rs_helppub only displays information about publications for which subscriptions have been created at that site.

Here are some examples of using rs_helppub:

To list all publications at a site, enter:
```
rs_helppub
```
The display output includes publication name, status, the primary Replication Server and database names, the number of articles, and the date of the latest change to the publication.
To display detailed information about a particular publication, enter:
```
rs_helppub publication_name, primary_dataserver, 
    primary_db
```
The display output includes the above information and the names of associated articles, replication definitions, and primary and replicate tables. If subscriptions have been created for the publication, the display includes names of the subscriptions, replicate databases, owners, and the date of the latest change to the subscription.
To display information about a particular article, enter:
```
rs_helppub publication_name, primary_dataserver, 
    primary_db, article_name
```
The output display includes the name of the publication to which the article belongs, associated replication definitions, status information, and where clauses and subscriptions, if any.

See Replication Server Reference Manual > Replication Server Commands > rs_helppub.