Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Sync Error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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