title: Lock SQL table for a period of time
body: <p>We are trying to test our new software here which is based on SQL 2005.
  We want to  see how it will respond when one of the tables which the  software is using during insert/update gets locked.</p>
  
  <p>Is there a way in SQL 2005 we can simulate this?
  so that we can see how we can handle the error on the front end?</p>