Posted on 2016-07-21
question about a trigger.
i have a trigger that fires off when an insert takes place on a table and then it populates another table with the exact same contents plus one extra column. I test it with ssms and it works fine..... only when i do one update statement at a time.
when i right a group of 4 or 5 update statements, highlight them all and f5 them in the ssms interface, the trigger will only add the first update statement, but i do find all 5 inserts on the original target table......
I might need to put more information in here but was hoping that someone might know what is probably going from the above description.