title: SQL: Will setting IDENTITY_INSERT ON disable updating the table's identity table?
body: <p>I'm currently working on a data migration project and for performance-related issues, I want to predefine a set of identities rather than letting the tables generate them.</p>
  <p>I found it's not easy to add the <code>identity</code> property to a column, so I want to use <code>IDENTITY_INSERT ON</code> statement.</p>
  <p>My question is: would this disable updates to the table's identity table (which is impacting performance), or do I need to truly remove the <code>identity</code> property of the column(s)?</p>