How to delete a merge publication (Transact-SQL)

To delete a publication (merge)

1. Execute sp_dropmergesubscription to delete all merge subscriptions.
2. Execute sp_dropmergepublication to delete the publication and all of its articles.
3. Execute sp_replicationdboption to disable replication of the current database.

Note Do not call sp_replicationdboption to disable publication of the current database if you are only deleting one publication and you still want to publish from the database.

See Also