title: How do you check if IDENTITY_INSERT is set to ON or OFF in SQL Server?
body: <p>I've searched for this, but threads in which it appeared tended to have answers from people who didn't understand the question.  </p>
  
  <p>Take the following syntax:</p>
  
  <pre><code>SET IDENTITY_INSERT Table1 ON
  </code></pre>
  
  <p>How do you do something more like this:</p>
  
  <pre><code>GET IDENTITY_INSERT Table1
  </code></pre>
  
  <p>I don't want to do anything whatsoever to the data in the database or to the settings to get this information though.  Thanks!</p>