I want to eliminate a table but this it marks the message to me:
Server: Msg 3724, Level 16, State 2, Line 1
Cannot drop the table 'NOM_TABLE' because it is being used for replication.
This pertenecia to one, but no longer exists the replication, now which I want to eliminate it leaves to me in error, already tries many things but I cannot even eliminate it, I want to think that the SQL I leave to this table with some estatus on the replication that pertenecia, but as I can eliminate it, some reference.
bye
try
sp_removedbreplication <dbname>
if that doesn't work try
Exec sp_configure 'allow updates', 1
Reconfigure With Override
go
update sysobjects set replinfo = 0 where replinfo <> 0
go
Exec sp_configure 'allow updates', 0
Reconfigure With Override
go
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment