>>>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.
>
>I actually tried to add a row (from my VFP application) and the value assigned was correct (that is it was next in sequence of the existing ones). What am I missing?
Actually, I've tried it and also remembered we discussed it before. Identity does indeed increment correctly.
If it's not broken, fix it until it is.
My Blog