This post thanks to the caveman blog! All hail the caveman blog!
http://cavemansblog.wordpress.com/2009/04/02/sql-how-to-add-an-identity-column-to-a-table-with-data/
This article demonstrates a step-by step procedure about how an identity column an be added to a table that has data. There are two ways of adding an identity column to a table with existing data:
1. Create a new table . . . → Read More: SQL Server: How to add an identity column to a table with data.