Identity insert on.

have a look , this works fine.

When IDENTITY INSERT IS on you have to list all the columns and values in the insert statement

use tempdb;
create table temp (id int identity(1,1), val char(1));

GO
set identity_insert temp on
insert into temp(ID,val) values(1,'A')
set identity_insert temp off

---

Satheesh