title: SQL Reset Identity ID in already populated table
body: <p>hey all.  I have a table in my DB that has about a thousand records in it.  I would like to reset the identity column so that all of the ID's are sequential again.  I was looking at <a href="http://www.mssqlcity.com/FAQ/Devel/reset_identity_column.htm" rel="noreferrer">this</a> but I'm ASSuming that it only works on an empty table</p>
  
  <p>Current Table</p>
  
  <pre><code>ID    |    Name
  1           Joe
  2           Phil
  5           Jan
  88          Rob
  </code></pre>
  
  <p>Desired Table</p>
  
  <pre><code>ID    |    Name
  1           Joe
  2           Phil
  3           Jan
  4           Rob
  </code></pre>
  
  <p>Thanks in advance</p>