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

To delete a pull subscription (merge)

• Execute sp_dropmergepullsubscription to delete the subscription.

To disable publications that allow anonymous subscriptions (merge)

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.

See Also