Remove TABLE from merge replication

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups

DB Engine

SQL Server MSDE SQL Server CE

Services

Analysis (Data Mining)Analysis (OLAP)DTS Integration Services Notification Services Reporting Services

Programming

CLR Connectivity SQL XML

Other Technologies

Clustering English Query Full-Text Search Replication Service Broker

General

Data Warehousing Performance Security Setup SQL Server Tools Other SQL Server Topics

Directory User Groups

Related Topics

MS Access Other DB Products MS Server Products .NET Development VB Development Java Development More Topics ...

SQL Server Forum / Other Technologies / Replication / March 2006

Remove TABLE from merge replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SouRa - 31 Mar 2006 15:06 GMT

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,
Soura

Reply to this Message

Paul Ibison - 31 Mar 2006 15:36 GMT

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)

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2009 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.