error msg '80040e14' ----Urgent help!!

[sunnydreams]

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,

 

[cLFlaVA]

yes. you are trying to insert a record into the database, where the primary key of the record you are trying to insert already exists.

you cannot insert a value that is intended to be unique if it already exists in the database.

*cLFlaVA
----------------------------
[tt]I already made like infinity of those at scout camp...[/tt]
beware of active imagination: [URL unfurl="true"]http://www.coryarthus.com/[/url]

BillyRayPreachersSonIsTheLeetestHax0rDude

 

[DotNetGnat]

That error means that you are trying to insert a duplicate record...i mean you are trying to insert a second record with the same ID

make sure that got rid of all duplicates and then do your insert statement again...

-DNG