Results 1 to 5 of 5

Thread: Merge Replication

  1. #1
    Join Date
    Aug 2010
    Posts
    2

    Merge Replication

    Hi,

    I used Microsoft SQL Server 2000 to configure merge replication.I had two servers as publishers and one server as subscriber.Previously I had 9 articles in a publication. However, I wanted to have 8 articles only and therefore what I did is :

    1) Stop synchronising.
    2) Delete publication in 'Create and Manage Publication'.
    3) Create back the publication with 8 articles only.

    I re-created publications for 12 databases but only one failed.
    After re-creating the publication, I got an error message says
    "The process could not drop one or more tables because the the tables are used by other publications."
    Error number : -2147200976

    I tried deleting and creating publications again but failed with same error message.

    Anyone have any idea what cause this and how can I solve this?Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You have two publishers or one publisher?. Is there any other publication on the same server?.

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    Double check if the db has multiple publications.

  4. #4
    Join Date
    Aug 2010
    Posts
    2
    I have two publishers. There are other publications on the same server but on different db. I've checked the db but it did not has multiple publications.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Revome replication for that db again then check with 'sp_dboption db_name', ensure there's no 'published' in result.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •