title: SQL Server generated bug data script how not to set the IDENTITY in the insert statements?
body: <p>I'm using SQL Server Management Studio to generate a SQL script (big one) to update an Azure SQL database. The problem is that the script is generated with <code>IDENTITY</code> on and the insert statements are exported with the ID column which as result cause this error :</p>
  
  <blockquote>
    <p>Cannot insert explicit value for identity column in table 'Table_Name'
    when IDENTITY_INSERT is set to OFF.</p>
  </blockquote>
  
  <p>My question is how to generate the script right that is will not use IDENTITY on and the insert?</p>