• Triggers in SQL Server are fired once regardless of the number of rows inserted/updated/deleted. If the possibility exists, you need to code your triggers to handle multiple rows.

    I'd start by reading BOL (Books Online). If that creates more questions than answers, come back and ask specific questions for clarification.