I am trying to have a trigger fire when the Merge agent\user insert\delete\update data. The trigger inserts data into a log table. I don't want to use NFR (Not For Replication) because I need that the trigger will fire when merge agent inserts data.
At first, I thought it was the problem with the replication but when I change the triggers into NFR everything was working fine. (which is not good because I need them to fire when the merge agent inserts data as well).
Then I thought it was a problem with the triggers but when I insert\update\delete data using t-sql the triggers are working fine.
The problem is that the data is not synchronized as it should be in merge replication. When I update a column, I can't see it on the other database unless I'm changing the trigger into Not For Replication or disabling them.