How To
How to Delete a Push Subscription (Transact-SQL)
To delete a push subscription to a snapshot publication
- Execute sp_dropsubscription to delete the subscription.
- Execute sp_dropsubscriber to remove the registration entry of the Subscriber.
Note It is not necessary to drop a Subscriber unless you are dropping the last publication to which it subscribes.
To delete a push subscription to a transactional publication
- Execute sp_dropsubscription to delete the subscription.
- Execute sp_dropsubscriber to remove the registration entry of a Subscriber.
Note It is not necessary to drop a Subscriber unless you are dropping the last publication to which it subscribes.
To delete a push subscription to a merge publication
- Execute sp_dropmergesubscription to delete the subscription.