title: How to detect a record is locked?
body: <p>With SQL Server 2008, how can I detect if a record is locked?</p>
  
  <p>EDIT:</p>
  
  <p>I need to know this, so I can notify the user that the record is not accessible because the record is blocked.</p>