title: Cannot update identity column SQL Server 2014
body: <p>I am trying to update the Identity column, and it does not exists in any relational table as of now.</p>
  
  <p>If I run the SQL statement as shown:</p>
  
  <pre><code>SET IDENTITY_INSERT Client..dt_Domain ON;
  
  UPDATE Client..dt_Domain
  SET DomainID = 1
  WHERE DomainID = 2 AND ClientID = 3
  
  SET IDENTITY_INSERT Client..dt_Domain OFF;
  </code></pre>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>Msg 8102, Level 16, State 1, Line 6<br>
    Cannot update identity column 'DomainID'.</p>
  </blockquote>