How to delete a transactional push subscription (Transact-SQL)

To delete a push subscription (transactional)

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.

See Also