My organisation has ArcSDE enterprise geodatabase(ArcGIS 9.2) with MS SQL Server 2008 as DBMS.
When I compress the geodatabase I am getting the follwoing error
Failed to compress the database. Underlying DBMS error [microsoft][ODBC Driver11 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint'Value'. cannot insert dulpicate key in object'Value']
I ran the Diagnose versions table and then repair versions table but I still get the same compress error after executing repair.