all groups > sql server replication > march 2006 >
You're in the

sql server replication

group:

Remove TABLE from merge replication


Remove TABLE from merge replication SouRa
3/31/2006 6:06:02 AM
sql server replication:
Hi,

Nearly 100 tables are in merge replication and I need to remove 5 tables
from replication.

Is it possible? If so what are the steps I have to follow?

Please advise.

Thanks,
Re: Remove TABLE from merge replication Paul Ibison
3/31/2006 3:36:30 PM
Soura,
if you already have subscribers, you'll have to drop the subscriptions,
remove the tables then reinitialize. As a temp hack, you could disable the
triggers on the tables (edit them to comment out the code).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button