Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Need to drop a table from Merge replication in SQL 2005

Posted on 2007-10-16
Medium Priority
Last Modified: 2008-01-09
I have a client who is merge replicating between 4 offices, database is a little over 23GB.  I need to remove a table from the publication so that it's data is not replicated because the data in this table is site specific and the guy who did the replication accidentally put it in during a full resetup.

Client is running SQL 2005.  What would be the easiest way to accomplish this knowing that due to reasons outside my control it takes about 27 hours to rebuild replication from scratch for this client?
Question by:tesupport
LVL 38

Expert Comment

by:Jim P.
ID: 20087471
You should be able to go into the publisher and de-select the table. Give it a couple days of not being replicated, then drop it from the distributor, then drop it from the subscriber.
LVL 21

Accepted Solution

Kevin3NF earned 1000 total points
ID: 20087802
To delete an article from a merge publication:

1.Execute sp_dropmergearticle (Transact-SQL) to delete an article, specified by @article, from a publication, specified by @publication. If necessary, specify a value of 1 for @force_invalidate_snapshot and a value of 1 for @force_reinit_subscription.

2.(Optional) To remove the published object from the database entirely, execute the DROP <objectname> command at the Publisher on the publication database.

Books online for 2005....test first on a non-production system

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question