Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SQL Server 2008 Change Tracking property RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Can someone explain the relationship between Sync Framework and the 'Change Tracking' property I can set in SQL Server 2008 for each table.

    It seems as though this setting can be false/true and my Sync solution works fine.  Does setting this property effect Sync Framework 2.1, or is it ignored by teh Sync Framework 2.1?

    Thanks.

     

    Thursday, September 16, 2010 10:18 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    afaik, that is ignored by Sync Fx if your using SqlSyncProvider. The offline providers (the one used by the Local Database Cache project item in VS) supports SQL Change Tracking though and disabling change tracking on a table will affect Sync Fx if it was configured to use SQL Change Tracking.

    • Marked as answer by sbhuller Friday, September 17, 2010 3:26 PM
    Friday, September 17, 2010 12:56 AM