Cannot insert explicit value for identity column in table when IDENTITY INSERT is set to OFF

 

Received the following ODBC error when trying to insert a new record into a SQL Server table with the SQL Insert statement using RPG2SQL.

 

SQL Insert statement:

 

insert into shippers (ShipperID) Values('4')

 

ODBC Error:

 

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'table name' when IDENTITY_INSERT is set to OFF.

You need to omit the IDENTITY column from the table INSERT statement.  If the insert is being used as part of a stored procedure, you can then use @@IDENTITY field to get the assigned SQL Server assigned IDENTITY value for subsequent table inserts.