How to delete a transactional publication (Transact-SQL)

To delete a publication (transactional)

1. Execute sp_dropsubscription to delete all transactional 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