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

最新推荐文章于 2021-04-13 08:27:43 发布

neom

最新推荐文章于 2021-04-13 08:27:43 发布

阅读量1.7k

点赞数

文章标签： mssql 数据库

本文链接：https://blog.csdn.net/neom/article/details/44405653

版权

解决方法

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