>Hi,
>
>Say I have a table with some records. The primary key column (N (6,0) has unique values (of course). Then I make this column to be Identity column. Do I understand correctly that SQL Server will set the next row value of this column by incrementing the last/greatest existing value?
>
>TIA.
No. You need to correctly specify seed value.
If it's not broken, fix it until it is.
My Blog