Error 3724:Cannot drop the table 'object_name' because it is being used for replication.-ZT

原贴： http://blog.csdn.net/NinGoo/archive/2005/03/11/317150.aspx

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