IDENTITY_INSERT is set to OFF?
When a column is defined as IDENTITY you should not include it in the insert statement 
SQL Server by it self will insert the value.

    INSERT INTO MYTABLE([CODE],[NAME],[DOB]) VALUES (123,'BOND','01-04-1971')


If you look at the insert statement ID column is missing but still will get a incremented value upon executing this statement.