How to delete a snapshot publication (Transact-SQL)

To delete a publication (snapshot)

1. Execute sp_dropsubscription to delete all snapshot subscriptions.
2. Execute sp_droppublication 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 deleting only one publication and you still want to publish from the database.

See Also