none
Sync Error RRS feed

  • Question

  • Hi 

    I have developed a Sync Application to Sync SQL Server 2005 Express Edition SP2 and SQL CE 3.5 it works fine, but when i used SQL Server Standard Edition RTM and SQL CE i am getting the following error 

    "Failed to Execute Provider Command "SelectNewTimestampCommand". The transcation was rolled back. Ensure that the command syntax is correct and check the inner exception for any store-specific errors."

    can anyone please give me a solution.

    Thursday, November 4, 2010 9:29 AM

Answers

  • Hi,

    If your SQL Server Edition RTM is 2005 RTM, it doesn't have min_active_rowversion. This built-in function was added in SQL Server 2005 SP2. The failed "SelectTimestampCommand" needs min_active_rowversion.

    Thanks,
    Dong


    This posting is provided AS IS with no warranties, and confers no rights.
    Thursday, November 4, 2010 6:06 PM
    Moderator