01-29-2013 02:16 PM
I have a user that every 2 weeks gets the message:
Cannot insert duplicate key row in object 'sys.syscommittab' withunique index 'si_xdes_id'... error 2601" When Attempting to Backup, Repair, Creating Remote, Or Synchronize a Sage ACT! Database
I already did all that says the Answer ID 28141... but don't definitely worked.
09-03-2013 08:36 AM
09-10-2013 04:53 PM
If you apply SP1 to Microsoft SQL Server 2008 R2 (through Windows Updates or the Microsoft website), then run the batch file one more time to clear out any existing problems, you should no longer receive the error. This is a known SQL Server 2008 R2 issue.