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 can restore another database backup, that don`t have replications configured,  over the database that you want to delete(with the "force restore over existing database" option marked). Doing this you will overwrite the sysobjects lines that saves the replication parameters and the SQL Server will alow you to delete the database.

    I hope It`s easy to understand..

    Mila.