Did you know you can ALTER an existing column to give it the identity property? If you look up ALTER TABLE in the BOL index, you'll see this: ALTER TABLE table_name { [ ALTER COLUMN column_name {DROP DEFAULT | SET DEFAULT constant_expression | IDENTITY
Read More...