I&#039ve got a fairly simple insert trigger that updates a second table. It works perfectly for inserts with around 200 rows or less. When I want to do large inserts of around 5,000 (INSERT....SELECT statements) it only partially works. I can&#039t seem to trace where it fails, but the transaction goes through! There are definitely records that get added to the table that the trigger is on which do not get to the second table.<BR><BR>Does anybody know of trigger limitations??<BR><BR>HELP!!<BR>