Nope, there is no way to change this. For any modification, insert update or
delete, the trigger fires once no matter how many rows are affected. Note
that this even means even if 0 rows are affected, the trigger will fire.
see the number of rows. The virtual table 'inserted' will contain copies of
all the inserted rows.
MCSE, SQL Server MCT, MVP
Feed Someone for Free Today:
> We are creating a trigger on a table for insert, but for following
> command, the tigger fires once, rather than per row.
> insert into table1 select * from table2
> is there anyway to set it up, so it fires for each row being insered?
> I would appreciate any help and suggestions.
> Thank you,
> Sent via Deja.com http://www.deja.com/
> Before you buy.