title: Confusing IDENTITY_INSERT error, says it is already on in another table
body: <p>I'm trying to rebuild a database from a text file, using VBA. To insert the ID values, I call this before sending in the INSERTs:</p>
  
  <pre><code>SET IDENTITY_INSERT TableName ON
  </code></pre>
  
  <p>This seems to work fine for most TableNames, but when I call it on table 'Accounts' I get an interesting error:</p>
  
  <pre><code>"IDENTITY_INSERT is already ON for table 'test.dbo.PropertyAssets'. Cannot perform SET operation for table 'Accounts'."
  </code></pre>
  
  <p>I'm guessing this has to do with fkey constraints or such, but does anyone know for sure?</p>