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.