Viewing 2 posts - 1 through 2 (of 2 total)
Thanks Andres for your inputs. I realized that I did not ask the right questions:-
Why does SQL escalate an S lock to IX lock when there is no updates?
Thanks
October 14, 2005 at 12:40 pm
#597443
Thanks, I am confused about your reply though...I am not executing a query. I am reading from an error log similar to:-
Deadlock...
September 27, 2005 at 1:52 pm
#593452