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
or
sp_replicationdboption ‘MyDB’, ‘merge publish’, false depending on whether the publication was a merge replication or a different sort… Cheers
Twan

---

Twan It worked.
Thank u very much Pradsoh

---

]]>