Cannot drop the database XXX because it is being used for replication

最新推荐文章于 2025-09-24 10:57:04 发布

原创最新推荐文章于 2025-09-24 10:57:04 发布 · 1.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mssql #数据库

本文提供了两种解决SQL2000中无法直接删除数据库的问题的方法：一是重新创建复制然后删除；二是将数据库设置为离线状态再进行删除操作。此外，还提供了一段用于解除所有表的复制标志的脚本。

解决方法

1、Recreate a replication on this DB for the purpose dropping it. After I drop the replication, I was able to drop the DB.

2、将数据库Offline然后再删除就可以了

SQL 2000的脚本

-- Removes Replication Flag for all Tables in the Database
 -- using sp_MSunmarkreplinfo
 SET NOCOUNT ON
 DECLARE @tablename NVARCHAR(128)
 DECLARE @RC INT
 DECLARE curTable CURSOR FOR
 SELECT [name] AS tbl
 FROM sys.tables
 OPEN curTable
 FETCH NEXT FROM curTable
 INTO @tablename
 WHILE @@FETCH_STATUS = 0
 BEGIN
 EXECUTE @RC = dbo.sp_MSunmarkreplinfo @tablename
 FETCH NEXT FROM curTable
 INTO @tablename
 END
 CLOSE curTable
 DEALLOCATE curTable
 GO