How to Delete an Anonymous Subscription (Transact-SQL)

To disable snapshot publications that allow anonymous subscriptions

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.

To disable transactional publications that allow anonymous subscriptions

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.

To disable merge publications that allow anonymous subscriptions

1. Execute sp_dropmergearticle n times to delete each article in the publication.
   
   
2. Execute sp_dropmergepublication 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.