Post reply

SQL server 2000 Merge Replication Issues

  • October 31, 2008 at 1:08 am

    #71380

    Hi Friends

    I had configured for merge replication in sql server 2000.

    It was woking fine, all data has been merged to second server with same data from first server.

    I have seen and noted in first sql server, database all user tables recreated with name of conflict_table name with type name is system. but data has been merged successfully with time intervel.

    Please tell me, what actual problem? why all user tables recreated in database itself with name of conflict_table name and table type is system? is it any modification required?

    Thanks

  • October 31, 2008 at 2:23 am

    #892187

    Hi,

    Don't worry, these tables are used by replication to track conflicts. For each table in your replication, a MSmerge_conflict_ table will be created (we don't RECREATE your actual tables).

    If there is a conflict, the loosing row ends up in the corresponding conflict table (the winner obviously ends up in the actual table).

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • October 31, 2008 at 2:47 am

    #892193

    Hi elisabeth,

    Thank you very much for your valuable reply.

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

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