So, are you sure that the version of the trigger that got applied at the subscriber is the correct one? Just trying to think of explanations. I use the NOT FOR REPLICATION on dozens of triggers and all works as expected.

Also, when and where do you get the nested error? At the time of the original update at the publisher, or when the replication agent is proprogating the update at the subscriber?

Jay Madren