Slightly off the track, but if you didn't want a distinct search, and wanted to have an incremental field count WITHOUT using IDENTITY, then try this [assuming the above test...

Short of changing the table definition through EM, there is no scriptive way of doing what you are trying.

You cannot ALTER TABLE to make a column an IDENTITY, but you...

Another thought: Create the table from an SP into the TEMPDB at SQL start-up if the values do not alter often, but are needed often. The result is a faster...