Most of the time, it could save the changes with maybe 2-3 UPDATE statements, and that's it.<BR><BR>So, like the title says, I want to find out what SQL statement caused a trigger to fire. have ...

This, of course, causes the trigger to fire AGAIN, but it gets filtered through the IF UPDATE again, and this block finally updates nothing and the trigger finishes, not being fired again.