>>
>>Thank you again for the link to sqlauthority web site. It works very well. Now my Site Numbers are zero-based. And if DBA asks, I will tell him/her that I am following MS logic which has many entities zero-based.
>
>Why you want it to be identity in the first place? Based on you description IDENTITY attribute should not be needed.
There is a form in the application where user can add Sites (to the table named Sites). When he/she adds a site, the added (new) record is set to the next Identity number (column SITE_NO). Why would the Identity attribute not needed in this case?
"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