Need to drop a table from Merge replication in SQL 2005

Posted on 2007-10-16
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.
    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

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now