cannot insert explicit value for identity column in table when identity_insert is set to off.

Question

Problem :

I am facing following error while executing script

cannot insert explicit value for identity column in table when identity_insert is set to off.

Answer 1

I guess you are inserting values for an identity column.

You can easily turn on identity insert on the table like shown below to specify your own identity values.

e.g.

SET IDENTITY_INSERT Table1 ON

INSERT INTO Table1
/*Please note the column list is REQUIRED here not optional*/
            (OperationID,
             OpDescription,
             FilterID)
VALUES      (20,
             'Hierachy Update',
             1)

SET IDENTITY_INSERT Table1 OFF