Andy,

The trigger will fire once and once only and it could be an insert trigger or an instead-of trigger. In sql server 7, this will happen after the insert occurs, and there is no possibility of the instead-of option.

It will only work for the first record in the recordset becaused triggers fire once only.

Jeff Bennett