Post reply

Inserts on 1 table not replicating to subscription

  • May 1, 2009 at 8:21 am

    #99678

    I am using SQL server 2000 Merge Replication. Some time in the last few months one of the SQL tables stopped replicating inserts to the subscriber. After investigation I found that once an insert occurs in the SQL table a recod is written to the msmerge_contents table but not the msmerge_genhistory table.

    Now I can insert records on this table at the subscriber and the insert will replicate up.

    I have check and there are no conflicts

    I REALLY would appreciate some help on this.

  • May 4, 2009 at 10:45 am

    #988195

    Its wierd ... I am working on transaction replication, but i would say... is your replication working? do you see any red mark on your replication monitor?

    Thanx.
    Vinay

    http://rdbmsexperts.com/Blogs/
    http://vinay-thakur.spaces.live.com/
    http://twitter.com/ThakurVinay

  • May 4, 2009 at 10:52 am

    #988199

    All indications are that everything is fine and working but that 1 table. All other tables in the DB are replicating fine. Any inserts to that 1 table that is at the publication does not replicate down to the subscriber but if I make the change at the subscriber for that table it does replicate back up to the Publication.

    I would hate to have to reinitialize but if I don't get it fixed by Wednesday that is what I am going to do.

    Thanks,

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply