How to Delete a Pull Subscription (Transact-SQL)

To delete a pull 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.

To delete a pull subscription (transactional)

1. Execute sp_dropsubscription to delete the subscription.
   
   
2. Execute sp_dropsubscriber to remove the registration entry of the Subscriber.
   
   
3. Execute sp_droppullsubscription at the Subscriber.

To delete a pull subscription (merge)

• Execute sp_dropmergepullsubscription to delete the subscription.