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?
 
rboyd56Connect With a Mentor Commented:
use the sp_lock procedure
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
sp_Lock
0
All Courses

From novice to tech pro — start learning today.