Cannot insert explicit value for identity column in table

[jpraveen]

Hi

when iam inserting the data in the table i am getting the error as shown below

APT_CombinedOperatorController,0: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'Table_Name'when IDENTITY_INSERT is set to OFF.

for the table we had select ,delete,update and insert previlages,
so how to resolve it?

[nitkuar]

Are you trying to insert values in identity column? Could you please check your table's ddl script.

[chulett]

Talk to your DBA. That or stop trying to insert explicit values into the IDENTITY column.