Error message Cannot insert duplicate key in SQL Server

[Former Member]

On an agent handler, in server_XXXXXXX.log, I see this error Microsoft SQL Server Native Client 11.0, desc=Violation of PRIMARY KEY constraint 'PK_ComputerProperties'. Cannot insert duplicate key in object 'dbo.EPOComputerPropertiesMT'. The duplicate key value is (533)., msg=IDispatch error #3092 It seems that this problem is described in KB92709 and the technical support can provide the query to clean this duplicated key in SQL server. Thank you very much for your help

[cdinet]

That is a different table in that KB and any query for that would not be applicable to your error.  This is kb Cannot insert duplicate key in object 'dbo.EPOEventsReference

You probably need to find what key value 533 is.  Run the following query -

select * from epocomputerpropertiesmt where id=533