List all Locks of the Current Database

This Transact-SQL script list all locks with details currently existing in the selected datadase.With this script you can see who is locking which objects,check exclusive locked object,watching lock escalation during long running DML statements,from key,page to object lock.

 
 
 
 
 
(16)
3,772 times
Add to favorites
Databases
9/20/2011
E-mail Twitter del.icio.us Digg Facebook