THANKS! Using a transaction isolation level of Repeatable Read actually prevents the deadlock. The only drawback is I have to start a transaction...
How do I set the transaction isolation level to REPEATABLE READ? Can this be handeled in the trigger? Because I don't normally start explicit...
Ok I got news for everyone. Here is the test application I did to reproduce the deadlock constantly (C# .Net Win Form application with sources):...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
quote:Originally posted by FrankKalis Strange. Consider this just a WAG, but what happens when you change IF @@ROWCOUNT=0 RETURN to IF @@ROWCOUNT>0...
quote:Originally posted by mmarovic As Adriaan already asked, is that the only trigger on that table? I hope so, otherwise I would have to admit...
quote:Originally posted by Adriaan The trigger script that you posted is OK in itself - is it the complete trigger, or could it be there's nothing...
quote:Originally posted by dineshasanka http://www.samspublishing.com/articles/article.asp?p=31524&seqNum=6&rl=1 Sorry but this does not answer...
The Microsoft timestamp field changes its content whenever row content changes. However the timestamp value is binary and not relevant to time at...
quote:Originally posted by dineshasanka Then, I don't think there is a option other than the Update Trigger, or else you have to handled this by the...
quote:Originally posted by mmarovic How about using default (getDate()) instead? I guess all you want is to set date of last change. Precisely, I...
I use an UpdateDT datetime field on all tables I want to track the last modification date. This field is updated by a trigger in my Sql 2000...
Separate names with a comma.
