>>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?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham