There are currently several rows in the database, and I need to convert the primary key to an identity column. I have a script that works perfectly on my test database to clean up the IDs and make sure they are sequential starting at 1.
What SQL statement should be used to add an identity property to the column?