Monday, March 19, 2012

drop manually table (on the subscriber) that was part of merge p

Hi ,
I am trying to drop manually table (on the subscriber) that was part of
merge publication before but got the below message. The publication was
dropped using E.M and even when try to re-create merge publication and add
this table it failed due to the fact that the it can not drop the specific
table on the subscriber .
Can I find any system store proc that force drop this table? Can I drop
it manually from system table (what tables )?
The message is :
Cannot drop the table 'XXXX' because it is being used for replication.
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 subscriber database, but obviously must only be done if this database is
not also configured as a publisher.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment