title: How to use transaction and select together, with sql2008
body: <p>we have a ASP.NET site with a SQL2008 DB.</p>
  
  <p>I'm trying to implement transactions in our current system. </p>
  
  <p>We have a method that is inserting a new row to a table (Table_A), and it works fine with transaction. If an exception is throwed, it will do the rollback.</p>
  
  <p>My problem is, that another user can't do anything that invole with Table_A in the same time - probably because it's locked.</p>
  
  <p>I can understand why the transaction have to lock the new row, but I don't want it to lock the whole table - forcing user_B to wait for user_A to finish.</p>
  
  <p>I have tryed to set isolationlevel ReadUncommitted and Serializable on the transaction, but it didn't work.</p>
  
  <p>So i'm wondering if I also need to rewrite all my select methods, so they are able to select all the rows except the new row there is in the making?</p>
  
  <p>Example:</p>
  
  <ul>
  <li>Table T has 10 rows(records?)</li>
  <li>User A is inserting a new row into table T. This take some time.</li>
  <li>At the same time, User B want to select the 10 rows, and dosn't care about the new row.</li>
  </ul>
  
  <p>So I guess I somehow need to rewrite user B's select query from a "select all query" to a "select all rows that isnt bind to a transaction query". :)</p>
  
  <p>Any tips is much appriciated, thanks.</p>