Thanks for that, the problem is that it dosn't give very much information, I was thinking more of a script which tells me if the lock type is
RS - Row Share
RX - Row Exclusive
S - Share
SRX - Share Row Exclusive
X - Exclusive
I found the following script on the internet but was wondering if...
I was wondering if anyone has a simple script that they could pass on which would help me to identiy any locks within an active database.
I know I could use the SQL Lock Manager but I'd rather not.
Many thanks. :-)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.