SQL Server Error Message: Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF
Error Message:
Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table <Table Name> when IDENTITY_INSERT is set to OFF.
Causes:
This error occurs when you are trying to insert into a table that contains an identity column and you are assigning a value to the identity column instead of letting SQL Server assign the value.
Need Additional Assistance?
Xynomix and we'll assess your issue and help to action a fix.
Contact Us
On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.
Testimonials
Enterprise Architect – North Yorkshire County Council
“Xynomix worked with us on our recent Oracle License Review and provided us with valuable independent and confidential advice to help us through what can be a confusing and complex process. They provided useful expert knowledge on Oracle Licensing policy and also suggested how any gaps could be most effectively licensed. I would certainly recommend working with Xynomix on any future Oracle License Review.”
Lead Database Administrator – Manufacturing Industry
“We have been running Microsoft SQL Server for around two years now and the systems have been supported by Xynomix. Their SQL DBAs are competent and very customer-facing.”
Data Systems Manager – Media Industry
“Xynomix investigated the performance bottlenecks that we were experiencing after updating our data warehouse application. After investigating the system, Xynomix concluded that the database server’s cache-hit rates and available memory were both low, which was impacting negatively on performance. The technician rectified this and we are now very happy with the function of the application.”
IT Infrastructure Engineer – Welcome Finance
“A recent project required the redaction of a large volume of data against a strict deadline. Xynomix were able to take a copy of the data and carry out the work all whilst maintaining the meaning of the data for review by other parties, within the deadline. The technical expertise and swift proactive support of the Xynomix team has ensured that even during a challenging period for Welcome Finance, we are able to ensure that our data and database performance is consistent which, in turn enables us to focus on additional projects.”
