Your conclusions are correct. SQL Server's triggers are
statement level, not row level. Best solution is to code
your triggers to support > 1 rows in inserted/deleted.
>I am running SQL Server 2000
>Will trigger happen on each insert when doing a select
>From what I am finding out it doesn't. I just tried this
>and in a trigger on the destination table get a record
>count > 1 in the inserted table when doing a select into
>and the select into has more than one reocrd.
>I thought the inserted table would only have one record?
>Why is this happening? How can I work around this?