title: How to enable Identity_insert on SQL Server Level
body: <p>In the article <a href="https://support.microsoft.com/en-us/help/4568653/fix-insert-exec-doesn-t-work-when-you-insert-row-containing-explicit-i" rel="nofollow noreferrer">https://support.microsoft.com/en-us/help/4568653/fix-insert-exec-doesn-t-work-when-you-insert-row-containing-explicit-i</a>
  it said :</p>
  <blockquote>
  <p>INSERT EXEC doesn't work when you insert row containing explicit
  identity value into table with IDENTITY column and IDENTITY_INSERT is
  OFF by default in SQL Server</p>
  </blockquote>
  <p>This means IDENTITY_INSERT can be set OFF by default in SQL Server and in the same manner ON.
  Does someone know how to achieve this?</p>