Home Forums SQL Server 7,2000 Replication Cannot drop the database XXX because it is being used for replication. RE: Cannot drop the database XXX because it is being used for replication.

  • You must use the next:

    use master

    GO

    sp_configure 'allow updates', 1

    GO

    RECONFIGURE WITH OVERRIDE

    GO

    to allow updates over system databases

    When you finish the operation, yo must run the next:

    use master

    GO

    sp_configure 'allow updates', 0

    GO

    RECONFIGURE WITH OVERRIDE

    GO