title: How to check which locks are held on a table
body: <p>How can we check which database locks are applied on which rows against a query batch? </p>
  
  <p>Any tool that highlights table row level locking in real time? </p>
  
  <p>DB: SQL Server 2005</p>