>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.