title: Reset identity column for existing values without deleting existing records
body: <p>I have table having 100000 records. In this, I have one column which is Identity column. Now I want update all these records for Identity column only. I want to update all existing identity reseed and start from 3000.</p>
  
  <p>I found this query but it only works for new records:</p>
  
  <pre><code>DBCC CHECKIDENT ('[Patient]', RESEED, 3000);
  </code></pre>