When I execute the following script:
values (20,'Hierachy Update',1)
I'm having the following 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.
What is the error about, and how it can be resolved?