[jdjlist] Problem Using Sql server trigger

[Jissy]

Hi All   Can anyone help me solve the problem I'm facing using Sql server triggers.   I have a trigger as follows:   create trigger test4_tgr on test4 for update as declare @id int declare @name varchar (60) select @id=testid, @name=testname FROM INSERTED INSERT INTO test5 (testid, testname) values (@id, @name);   The problem is that if execute an update sql, and the sql execution results in more than one row getting updated in test4, only one row gets inserted into table test5, corresponding to the last row that was updated in table4. So, i'm unable to track all updations done on table test4.   Does anyone know of any list where I can post this question?   Thanks Jissy     To change your membership options, refer to: http://www.sys-con.com/java/list.cfm