title: Reset AutoIncrement in SQL Server after Delete
body: <p>I've deleted some records from a table in a SQL Server database.</p>
  <p>The IDs in the table look like this:</p>
  <blockquote>
  <p>99
  100
  101
  1200
  1201...</p>
  </blockquote>
  <p>I want to delete the later records (IDs &gt;1200), then I want to reset the auto increment so the next autogenerated ID will be 102. So my records are sequential, Is there a way to do this in SQL Server?</p>