Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF

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?

Looking for a second opinion on a SQL Server error code? Get in touch with
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

    Success Stories
    Testimonials

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

    Read More »
    Success Stories
    Testimonials

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

    Read More »
    Application Manager - Banham Group
    Testimonials

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

    Read More »