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

IT Manager – Public Sector
“We first approached Xynomix for advice on Oracle licensing. They saved us money there, and a year on we have a full database management contract with them.”

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.”

IT Manager – Trade Union
“Since 2003 Xynomix have provided support and consultancy for our Oracle and SQL Server databases. We’ve found their knowledge to be extensive and they’ve ensured that our databases run smoothly with very little downtime. The flexibility and creativity that Xynomix show when working with us enables us to meet budgets and hit our project timescales.”

Business Services – Director
“We do not have the resources to employ full time DBAs. Xynomix give us the confidence to go out and win new business, knowing that we can deliver our services and our systems can cope.”