SQLTeam.com | Weblogs | Forums

Replication & Triggers Not for replication option


#1

Hi guys, I have a doubt about replicate a table that trigger an update on other table: the typical inventory movement table that update inventory table. I m using merge replication so when Merge Agent replicate an insert on movement table it update the inventory table, but then it also update again the inventory table because it is include in replication process, well i change the trigger using NOT FOR REPLICATION clause.
But I like to do this: not replicate inventory table and change will be take into account when the movement table is updated...How I have to configure inventory table and/or movement table to do that? TIA.