title: RESEED identity columns on the database
body: <p>Can I use the </p>
  
  <pre><code>DBCC CHECKIDENT(&lt;table_name&gt;, RESEED, value)
  </code></pre>
  
  <p>command to reset an identity column current value to the original one in SQL Server 2008?</p>
  
  <p>If yes, is this the correct way of doing this operation without having any drawback?
  If not, is there an alternate way of doing this?</p>