January 4, 2007 at 9:09 am
I have a database that in production is replicated. When I take the backup file of this and restore it in our dev environment where we are not replicating, it still thinks it is replicating. I'm not sure how to fixe this issue. I want to drop a table in dev but I cannot because it provides the below error. It does not have the hand on the db in dev.
Server: Msg 3724, Level 16, State 2, Line 2
Cannot drop the table 'Prospect' because it is being used for replication.
January 6, 2007 at 2:28 am
When you enable a table to paricipate in replication, the replinfo column in sysobjects is set to a non-zero number. When you attempt to drop a table, SQL Server first checks the replinfo column in sysobjects. If this column is zero, it will drop the table. If it is not zero, it will throw an error message that you can not
drop the table.
update s set replinfo = 0 from sysobjects s
where name = 'Prospect'
go
drop table Prospect
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply