Wednesday, March 28, 2012

Replication Error

I have a copy of a database "db_A" called "db_copy". When I try to alter
tables in the database, it complains that it is being used for replication.
It is not being used for replication, but the database that it was copied
from is.
Is there anything I can do to allow us to alter this database's tables?
Thanks
Sean
Sean,
there is a stored procedure to do this called sp_MSunmarkreplinfo which
takes a tablename as a parameter. Alternatively, setting replinfo to 0 in
sysobjects for the particular table should do it. Finally, running
sp_removedbreplication can be used to remove all traces of replication in
the database.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

No comments:

Post a Comment