Hello I have a table called MyTable with an UpdateTimeStamp column (of type datetime). There is an after update trigger that supposedly updates that column whenever a certain field is changed. An application is being used to modify that field. The end-user reports that whenever the modification is attempted, the application raises an error (an ODBC error). if update(SomeField1) or update(SomeField2) begin update MyTable set UpdateTimeStamp = GetDate() from MyTable as pc inner join updated as u on u.PKField = pc.PKField where IsNull(pc.SomeField1,'') <> IsNull(u.SomeField1,'') or IsNull(pc.SomeField2,'') <> IsNull(u.SomeField2,'') end Let's suppose that the application locks the table when it tries to modify it in such a way that the trigger cannot put a value in the UpdateTimeStamp column. Having a parallel table MyChangeTable (PKField, UpdateTimeStamp) would solve my problem? Or there is something that I can do to the trigger in order to prevent the error? Any ideas? Thanks a lot.