How to delete a transactional pull or anonymous subscription (Transact-SQL)

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 disable publications that allow anonymous subscriptions (transactional)

1. Execute sp_droparticle n times to delete each article in the publication.
2. Execute sp_droppublication to delete the publication.
3. Execute sp_replicationdboption to disable replication of the current database.

Note Anonymous subscriptions are unknown to the Publisher. The preceding steps disable all anonymous subscriptions to a publication by dropping the publication.

See Also