title: Insert a value of 0 into identity column
body: <p>I am trying to insert a value of 0 into a column of a table which has existing data. 
  The identity column is (1,1). Do I need to delete the existing data in order to insert a value of 0?</p>
  
  <pre><code>SET IDENTITY_INSERT table ON
  INSERT INTO table (id,...) Values(0,.....)
  SET IDENTITY_INSERT table OFF
  </code></pre>
  
  <p>I tried to run this but the script just hangs.</p>