Nested Triggers
Triggers can cause other triggers to fire if the nested triggers option has been enabled with sp_configure. Triggers can fire themselves recursively if the recursive triggers database option has been enabled. The @@NESTLEVEL automatic variable returns 1 within a first-level trigger, 2 within one it causes to fire, 3 for any it causes to fire, and so forth.