title: Reset autoincrement in Microsoft SQL Server 2008 R2
body: <p>I created a primary key to be autoincrement.</p>
  
  <ul>
  <li>I added two rows: <code>ID=1, ID=2</code></li>
  <li>I deleted these two rows.</li>
  <li>I added a new row, but the new row's ID was: <code>ID=3</code></li>
  </ul>
  
  <p>How can I reset or restart the autoincrement to 1?</p>