How To
How to Delete an Anonymous Subscription (Transact-SQL)
To disable snapshot publications that allow anonymous subscriptions
- Execute sp_droparticle n times to delete each article in the publication.
- Execute sp_droppublication to delete the publication.
- 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.
To disable transactional publications that allow anonymous subscriptions
- Execute sp_droparticle n times to delete each article in the publication.
- Execute sp_droppublication to delete the publication.
- 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.
To disable merge publications that allow anonymous subscriptions
- Execute sp_dropmergearticle n times to delete each article in the publication.
- Execute sp_dropmergepublication to delete the publication.
- 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.