>>>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=нет
>:)

Well, the name of this setting, IMHO, is counter intuitive.