title: SQL Identity (autonumber) is Incremented Even with a Transaction Rollback
body: <p>I have a .net transaction with a SQL insert to a SQL Server 2005 database. The table has an identity primary key. </p>
  
  <p>When an error occurs within the transaction, <code>Rollback()</code> is called. The row inserts are rolled back correctly, however the next time I insert data to the table, the identity is incremented as if the rollback never occurred. So essentially there are gaps in the identity sequence. Is there any way to have the <code>Rollback()</code> method reclaim the missing identity? </p>
  
  <p>Am I not approaching this the right way?</p>