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

To delete a pull subscription (snapshot)

1. Execute sp_dropsubscription to delete the subscription.
2. Execute sp_dropsubscriber to remove the Subscriber’s registration entry.

To disable publications that allow anonymous subscriptions (snapshot)

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