SQL Server Performance Forum – Threads Archive
Deleting a published databaseHi 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