SQL Server 2000 Forums SQL Server Development (2000) Trigger: Author: Topic: supersql Yak Posting Veteran. 99 Posts. Posted - 2005-09-20: 13:28:21. Can I write a trigger that fires like. when new rows(5) are inserted into a table,I want the IDENTITY values of this 5 rows to be inserted into its child table where it has the same column as FK. If its possbile to write a trigger,can any one.