How to Delete a Push Subscription (Transact-SQL)

To delete a push subscription to a snapshot publication

1. Execute sp_dropsubscription to delete the subscription.
   
   
2. 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

1. Execute sp_dropsubscription to delete the subscription.
   
   
2. 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.