Auditing merge replication changes...

  • Greetings,

    Afraid to say I know darn little on auditing... even less when replication is involved.

    What I'm looking for is what changed, when, and who.

    Example:  I synch up a tablet in from the field where the user has made changes to the database.  The synchronization goes thru fine and I get a return status msg

    Merged 5 data changes (0 inserts, 5 updates, 0 deletes,0 resolved conflicts)

    I don't suppose there is an easy way to find out what the 5 updates were without having to go thru and put insert/update/delete triggers on everything is there?

    Thanks,

    Chris

     

  • Triggers is what you need! Just rememeber to place the NOT FOR REPLICATION statement in the Triggers!


    Kindest Regards,

  • Hrmmm... was afraid that you were going to say that....

    Thanks,

    Chris

     

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

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