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.

  • July 17, 2008 at 2:11 pm

    #844652

    This will let you update. This is dangerous so make sure to run allow updates 0

    sp_configure 'allow updates',1

    GO

    RECONFIGURE WITH OVERRIDE

    GO

    update sysdatabases set category=0 where name = 'xxx'

    sp_configure 'allow updates',0

    GO

    RECONFIGURE WITH OVERRIDE

    GO