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
博客指出当试图删除或变更table时,若出现因表用于复制而无法删除的错误,典型情况是该表曾用于复制后又删除了复制。同时给出处理办法,通过一系列SQL语句操作,如配置参数、更新sysobjects表等解决问题。
2124

被折叠的 条评论
为什么被折叠?



