Lock:Timeout + urgent

[Don Nelson]

hi,
I am using SQL server 2000.and trying to resolve a deadlock issue.For
this i am looking at SQL profiler.and while turning the trace on, i
select Lock:Timeout event that needs to be traced.When done so, and
executing other requests, there appears an entry which just mentions
spid number, text data field is empty. I would like to know if after
lock times out,then the processes which are waiting for the lock to be
released, are they re tried again.That is if a process is waiting on a
lock,and lock times out,does SQL server tries to retry the same
process again?and if yes then after how much time interval?and is it
possible to set/change this time interval?

Thanks in advance
don

[Ryan]

This is always helpful

http://www.sommarskog.se/sqlutil/aba_lockinfo.html

ju**************@rediffmail.com (Don Nelson) wrote in message news:<db**************************@posting.google. com>...

hi,
I am using SQL server 2000.and trying to resolve a deadlock issue.For
this i am looking at SQL profiler.and while turning the trace on, i
select Lock:Timeout event that needs to be traced.When done so, and
executing other requests, there appears an entry which just mentions
spid number, text data field is empty. I would like to know if after
lock times out,then the processes which are waiting for the lock to be
released, are they re tried again.That is if a process is waiting on a
lock,and lock times out,does SQL server tries to retry the same
process again?and if yes then after how much time interval?and is it
possible to set/change this time interval?

Thanks in advance
don