I have a web site...

sometimes the page is show me this kind of messege...



Microsoft OLE DB Provider for SQL Servererror '80040e2f'
Violation of PRIMARY KEY constraint 'PK_SessionAction'. Cannot insert duplicate key in object 'dbo.SessionAction'. infoMasterUtil.asp, line 720

how can i solve the problem..?

is the problem is in line 720 ? only ?

or i need to look in ather places ?

the problem it reported at line 720 because that is where the insert will be.

Your data is the problem, as the query is trying to insert identical data into a primary key column.

try to debug and get the primary key that you are trying to use for the insert statment.
Querey the database for that primary key, if it exists then thats your issue.

There are too many factors that could result in duplicating the primary key, specially if its not the tables auto generated ID, and when you are using a combo primary key.

one more suggestion, try to wrap a transaction around your insert statments, either in code or stored procs...

Easiest way to deal with this is to use the With (Ignore_Dup_Key=On) option. It's also the fastest. But, you need to consider it very carefully, and decide whether this is truly what your system needs.

As others have hinted at, there's a problem with your data, and the error you see is when a constraint prevents your data from going all out corrupt. That means there's a larger flaw in the system. Or, to put it another way, line 720 is only the most immediate, last stage "cause" of what you're seeing, but the problem doesn't live there.