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