Post reply

Where do delete conflicts come from?

  • August 31, 2007 at 6:27 am

    #373721

    Hi,

    Merge Replication in SQL2000, one central server, n notebooks with MSDE

    Situation:

    1. A notebook user updates a record and replicates this to the central server

    2. A different notebook user deletes the same record and replicates this to the central server.

    3. A delete conflict arises. We have the default resolver so the updated record wins (central server wins)

    Is there any way of seeing which machine (i.e. the name of the machine and user in 1) updated the record? The conflict tables just give us the name of the central server.

    Any help appreciated

    Chidd

  • August 31, 2007 at 6:46 am

    #730735

    chidd,

    no, you can't find the name of the machine or user unless you're table design tracks them. I always advice to have a column changedate and changeuser, especially when using merge replication.

    Markus

    [font="Verdana"]Markus Bohse[/font]

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

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