Groups | Blog | Home
all groups > sql server replication > december 2005 >

sql server replication : Eliminate a table


Julio
12/6/2005 4:54:34 PM
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.=20

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.

seanbell68 NO[at]SPAM gmail.com
12/6/2005 5:12:41 PM
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
AddThis Social Bookmark Button