Hi, I have 3 tables named employee, HR, Payroll they have similar column names in all these tables and they are under same schema and same database. I have a After Trigger on Employee table, called "TRIGEmployee" that notifies me if some inserts any records into the employee table and "commits the transaction". My question here is, If I'm inserting values into employee I need that inserted values to be inserted into HR and Payroll simultaneously. For the above scenario to happen, I created a another after trigger named "TrigHR" on Employee table and inside the trigger I'm trying copy the contents from the "select * from inserted" statement to to my HR table but instead I'm not able to do it. here is my trigger on HR table: Create trigger TrigHR on Employee for insert as --Try1 select * into HR from select * from inserted --try 2 insert into HR select * from inserted" commit Tran GO For Try 1 and Try 2 I'm not able to get the results.Can anyone help me in resolving this issue, please Thanks, Ravi G Varma.