justwantananswer@rediffmail.com (Don Nelson) wrote in message news:<dbd41fbb.0410210551.1b7f67e9@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