Detailed Description and Symptoms
Occasionally, an issue occurs where the status of Sync objects do not reset.
This problem has been associated with the following:
There is a known bug in the MS SQL SERVER that if 'Mars_Connection=Yes' is used, DEADLOCK's are not returned to the application. We highly recommend that this feature is turned off. We believe that once MARS is turned off that this behavior will no longer be occur.
following should be completed:
1) update the ms sql native client and update your DB to the latest service pack
The current client version is:
20110428/150850.350 - 20110423/104029.477 - U0003535 DB INFO: 'DRIVER-VER = 10.00.1600'
The current DB version is:
20110428/150850.350 - 20110423/104029.477 - U0003535 DB INFO: 'DBMS-VER = 10.00.2531'
2) turn off Mars_Connection (i.e.: "Mars_Connection=No")