Drops subscriptions to a particular article, publication, or set of subscriptions on the publication server.
sp_dropsubscription 'publication', 'article', 'subscriber'
where
Only the system administrator, database owner, and a remote connection from the subscription server can drop a subscription to an existing publication or article.
This example drops all articles from all publications and drops all subscriptions for all subscribers.
sp_dropsubscription 'all', 'all', 'all'
Execute permission defaults to the system administrator and database owner.
sysarticles, syspublications, syssubscriptions, sysservers
sp_addsubscription | sp_helpsubscription |
sp_changesubscription | sp_subscribe |
sp_changesubstatus | sp_unsubscribe |