SQL 2005 locks

Hi All

I need a Query to run in my SQL 2005 to display all the locks if any, I used sp_who, is there any other lock to user to identofy and clear the locks
LVL 2
ibmas4002Asked:
Who is Participating?
 
rboyd56Commented:
use the sp_lock procedure
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
sp_Lock
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.