Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF
I have the below error “cannot insert explicit value for identity column” when I execute the following script. What is the error about, and how it can be resolved?
Insert table(OperationID,OpDescription,FilterID)
values (20,'Hierachy Update',1)
Error:
Server: Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF.