Yes, this is the only trigger on that table and it causes deadlocks!Just to be sure, I made a simple. However this trigger is source of deadlocks. This field is updated by a trigger in my Sql 2000 database:CREATE TRIGGER Trig_MyTable_Update ON dbo.MyTable FOR INSERT, UPDATEAS IF RETURNUPDATE U SET UpdateDT = GETDATE()FROM MyTable U INNER JOIN INSERTED I ON U.Id = I.IdThis looked to me as a simple way of accomplishing what I needed. I use an UpdateDT datetime field on all tables I want to track the last modification date. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |