(转)SQL SERVER复制订阅无法修改表的处理办法

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

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

   处理办法：
   select * from sysobjects where replinfo >'0'

   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


原文: http://blog.csdn.net/stephenewong/archive/2006/08/02/1009830.aspx

转载于:https://www.cnblogs.com/Liuchfa/archive/2008/01/17/1043644.html