title: MS SQL Server (Ver 2008 or above) - How to recreate auto-incremental based in my ID column
body: <p>I have a table in csv file (with an ID as <code>numeric</code>). </p>
  
  <p>I manually uploaded the information from the file to a SQL Server data table (creating my ID column as <code>numeric</code>). </p>
  
  <p>But, I want to recreate my ID column as autonumeric ID column that continue the number with the latest entry. </p>
  
  <p>Example: the table have the ID 1, 5, 10. I want to recreate the auto-incremental (IDENTITY) ID column (leaving my old ID's) and next row insertion continue with ID 11.</p>
  
  <p>I suppose that doesn't exists a single method to achieve this. But I want to know the steps that I should follow.</p>