Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

error msg 80040e14 -Urgent help!

Hi all--

We are working with Microsoft SQL Server and when we try to insert a record into a table
called 'employee salary', we get the following errormessage:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_employee_salary'. Cannot insert duplicate key in object 'employee_salary'.

Do you have any idea what could cause this error.

Thx in advance,
[533 byte] By [sunnydreams] at [2007-11-11 7:11:48]
# 1 Re: error msg 80040e14 -Urgent help!
It means that a row already exists in the table with the same primary key as the one you're attempting to insert.
pclement at 2007-11-11 23:47:56 >