SQL Server Performance

Deleting a published database

Discussion in 'Performance Tuning for SQL Server Replication' started by Pradosh, Aug 4, 2004.

  1. Pradosh New Member

    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
  2. Twan New Member

    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
  3. Pradosh New Member

    Twan

    It worked.
    Thank u very much

    Pradsoh

Share This Page