title: How to perform a row lock?
body: <p>I want to lock one record and then no one may make changes to that record. When I release the lock, then people may change the record. </p>
  
  <p>In the meantime that a record is locked, I want to show the user a warning that the record is locked and that changes are not allowed.</p>
  
  <p>How can I do this?</p>
  
  <p>I've tried all the IsolationLevel levels, but none of them has the behavior I want. Some of the Isolation levels wait until the lock is released and then make a change. I don't want this, because updating is not allowed at the moment a record is locked.</p>
  
  <p>What can I do to lock a record and deny all changes?</p>
  
  <p>I use SQL Server 2008</p>