>>
I believe you are prohibited from inserting into an identity column.
>>
>>No, you can insert into identity column if you set IDENTITY_INSERT OFF for that table.>>
>>I believe that you really meant SET IDENTITY_INSERT ON
>
>Yes, I always got them mixed up, so when I need it (very rarely) I check documentation again.
A good way to remember is to note somewhere that:
on=да
off=нет
:)
"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