Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How are the SFx 2.1 *_Tracking tables maintained in SqlCe without SPs? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    SFx 2.1:

    Since SqlCe does not have stored procedures and triggers ... how are the *_Tracking tables updated?

    Wednesday, June 15, 2011 8:39 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Sql Ce has built-in change tracking in itself. if you look at your CE database, you will find new columns and tables prefix with "_sys"
    • Marked as answer by P H T Thursday, June 16, 2011 12:06 PM
    Thursday, June 16, 2011 1:24 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Sql Ce has built-in change tracking in itself. if you look at your CE database, you will find new columns and tables prefix with "_sys"
    • Marked as answer by P H T Thursday, June 16, 2011 12:06 PM
    Thursday, June 16, 2011 1:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks ... makes sense ... since SFx 2.x's framework can use CE's CT ... one might think they could have meade it an option to use SQL's CT!

    Thursday, June 16, 2011 12:43 PM