Chapter 3: Administering ASE Replicator

Getting information about replicate articles in subscriptions

You can get the following information about replicate articles in subscriptions:

The sp_helpreplicateconn procedure returns information about replicate articles in a replicate database.

To get information about all replicate articles in all subscriptions in a specific replicate database

Use sp_helpreplicateconn with the arts keyword, and specify a replicate database connection:
```
sp_helpreplicateconn arts, conn="conn_name"
```
where conn_name is the name of a replicate database connection.

The sp_helpsub procedure returns information about replicate articles in a specified subscription.

To get information about all replicate articles in a specified subscription

Use sp_helpsub with the arts keyword, and specify a subscription:
```
sp_helpsub arts, sub_name
```
where sub_name is the name of a subscription.