Deleting a published database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Deleting a published database

Hi I cannot delete a published database, even after deleting the publication. When trying, a message "Error 3724; Cannot drop the database ‘MyDB’ because it is being used for replication" comes. Can anybody pls help…. Pradosh
Have you tried running sp_replicationdboption ‘MyDB’, ‘publish’, false
sp_replicationdboption ‘MyDB’, ‘merge publish’, false depending on whether the publication was a merge replication or a different sort… Cheers

Twan It worked.
Thank u very much Pradsoh