Received database insert error:
Error: Cannot insert explicit value for identity column in table 'WCSSSALES' when IDENTITY_INSERT is set to OFF.
Where does the IDENTITY_INSERT get set to 'ON'?
This seems to be a configuration from the database side:
sql - Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF - Stack Overf…
I believe the insert will work without configuration if you remove identify columns (I belive the values are automatically generated for these columns)
Hope this helps!
**If the post solves your problem, mark it as "Correct Answer".**You can say "Thank you" by clicking the "star" in the post that helped you.
Retrieving data ...