title: SQL Server, How to set auto increment after creating a table without data loss?
body: <p>I have a table <code>table1</code> in SQL server 2008 and it has records in it. </p>
  
  <p>I want the primary key <code>table1_Sno</code> column to be an auto-incrementing column.  Can this be done without any data transfer or cloning of table?</p>
  
  <p>I know that I can use ALTER TABLE to add an auto-increment column, but can I simply add the AUTO_INCREMENT option to an existing column that is the primary key?</p>