You can get the following information about replicate articles in subscriptions:
All replicate articles in all subscriptions in a specified replicate database
All replicate articles in a specified subscription
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.
