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
Business Operations Manager – Manufacturing Industry
“In the manufacturing sector, we need flexibility and immediate assistance when things go wrong. Xynomix have achieved this brilliantly, and make sure that at least one DBA is available when we call with a problem at any time of the day or night.”
Application Manager – Banham Group
“The Oracle database supports a key ERP application which holds information on our customers, invoicing and fulfilment and is therefore essential to the successful day to day running of our business. For over 6 years, Xynomix has provided us with outstanding database support and expertise. We work with a number of Xynomix senior Oracle DBA’s who know our systems inside and out.”
IT Manager – Public Sector
“Xynomix provide us with remote monitoring and administration for Linux, as well as Oracle. The proactive monitoring aspect of our service has proved extremely valuable. Whenever potential issues have been recognised with the system, it has always been identified by the monitoring technology and Xynomix DBAs begin work on a preventative fix immediately.”
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.”
