Error 3724: Cannot Drop The Table 'Object

xiaoxiao2021-03-06  14

Server: MSG 3724, Level 16, State 2, Line 1canNot Drop the table 'Object_name' Because IT IS Being Used for Replication.

When you try to delete or change a table, the following error occurred.

The more typical situation is that the table used to copy, but later deleted replication

Treatment method:

sp_configure 'allow updates', 1goreconfigure with overridegobegin transactionupdate sysobjects set replinfo =' 0 'where replinfo>' 0'commit transactiongorollback transactiongosp_configure 'allow updates', 0goreconfigure with overridego

转载请注明原文地址:https://www.9cbs.com/read-48394.html

New Post(0)