I believe you want to mark the trigger NOT FOR REPLICATION. This will prevent the trigger from firing when the Merge Agent makes the update. Have a look at All about "Not for Replication"All about "Not for Replication".
Glorfindel
- 2.2k
- 5
- 18
- 26