title: Setting Identity to on or off in SQL server
body: <p>I want to set Is Identity property of a column to off and after inserting an explicit value setting it to on again.I've written this query :</p>
  
  <pre><code>SET IDENTITY_INSERT Tbl_Cartoons OFF
  </code></pre>
  
  <p>Although it executes successfully ,nothing changes in the table design.
  Please suggest a solution ,It's really crucial.</p>