Lists subscription information associated with a particular publication, article, subscriber, or set of subscriptions.
sp_helpsubscription [publication [, article [, subscriber ]]]
where
This stored procedure returns subscriber, publication, article, destination database, subscription status, and synchronization type.
This example returns all subscription information about the publication authors_publication and the article authors.
sp_helpsubscription authors_publication, authors
Execute permission defaults to the public group.
sysarticles, syspublications, syssubscriptions, sysservers
sp_addsubscription | sp_dropsubscription |
sp_changesubscription | sp_subscribe |
sp_changesubstatus | sp_unsubscribe |