错误 3724,无法除去表"xxx",因为它正用于复制。
比较典型的情况是该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
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
同时这里还有个KB
http://support.microsoft.com/kb/236308/en-us