|
Cannot insert explicit value for identity column in table '...' when IDENTITY_INSERT is set to OFF
.png)
In order to fix the above issue that would be shown in the Pending Queue, please follow the below steps:
•Please log in to SSMS with a user who has the necessary admin credentials.
•Navigate to the table in your database which you are saving into from Scan2x.
•Right-click on the table and select Design
.png)
•Select the desired column, and from the Column Properties section at the bottom of the screen, navigate to the Identity Specification section and make sure that (Is Identity) is set to NO..png)
|
