sys.sp_dropsubscription

Description

Drops subscriptions to a particular article, publication, or set of subscriptions on the Publisher. This stored procedure is executed at the Publisher on the publication database.

Syntax

sp_dropsubscription
[ [ @publication = ]
N
'publication'
]
[ , [ @article = ]
N
'article'
]
, [ @subscriber = ]
N
'subscriber'
[ , [ @destination_db = ]
N
'destination_db'
]
[ , [ @ignore_distributor = ] ignore_distributor ]
[ , [ @reserved = ]
N
'reserved'
]
[ , [ @publisher = ]
N
'publisher'
]
[ ; ]

Permissions

Only members of the fixed server role, the fixed database role, or the user that created the subscription can execute. Delete a Push Subscription sp_addsubscription (Transact-SQL) sp_changesubstatus (Transact-SQL) sp_helpsubscription (Transact-SQL)