Solving: Cannot insert explicit value for identity column in table ‘NewInventory’ when IDENTITY_INSERT is set to OFF.
SQL Server SET IDENTITY_INSERT At any time, only one table in a session can have the IDENTITY_INSERT property set to ON. If a table already has this property set to ON, and a