A trigger is tied to a table. The Inserted and Deleted table represent the changed state of that table. Doing an INSERT to another table that has a Insert trigger would create an Inserted table, but for that table. Doing an INSERT back into the same table is allowed and will cause the trigger to fire again recursively, as long as Recursive Triggers is enabled. Check the BOL for more information.

-Mike

>Would doing an insert inside of an insert trigger cause two 'inserted' tables to be created? If so, what would they be called, and how can a programmer know which one to call from where? If not, how would SQL keep track? What if both tables have insert triggers, and both call the insert table for values? (That is the case here).