现在的位置: 首页 > 综合 > 正文

Error 3724:Cannot drop the table ‘object_name’ because it is being used for replication.

2013年12月07日 ⁄ 综合 ⁄ 共 477字 ⁄ 字号 评论关闭

Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the table 'object_name' because it is being used for replication.

当你试图删除或者变更一个table时,出现以下错误
Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the table 'object_name' because it is being used for replication.

比较典型的情况是该table曾经用于复制,但是后来又删除了复制

处理办法:

sp_configure 'allow updates', 1
go
reconfigure with override
go
begin transaction
update sysobjects set replinfo = '0' where replinfo >'0'
commit transaction
go
rollback transaction
go
sp_configure 'allow updates', 0
go
reconfigure with override
go

抱歉!评论已关闭.