Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How are SFx 2.1 *_tracking tables maintained in Sql Server 2008 (w/o CT)? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I was surprised to find that SFx provisioning did not create any triggers in my database ... I thought the _tracking tables were maintained with triggers ...

    How are the _tracking tables maintained?

    Sunday, June 26, 2011 7:35 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Sync Fx should have created triggers (1 each for insert/update/delete) for each table in your scope. if these were not created then somethings wrong with the provisioning.
    • Marked as answer by P H T Monday, June 27, 2011 12:59 PM
    Monday, June 27, 2011 12:55 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Now I see them ...

    SQL Server 2008 CT has a setting for how long CT information is retained before it is automatically removed ... how does this happen w/o CT?  For example, _tracking table records that track deletes ... how long do they stay in the _tracking table and what triggers them to get deleted?

    Tuesday, June 28, 2011 1:24 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    you can specify retention and metadata cleanup via the API, see: http://msdn.microsoft.com/en-us/library/ee617373(v=SQL.110).aspx

     

    • Marked as answer by P H T Tuesday, June 28, 2011 4:08 PM
    Tuesday, June 28, 2011 1:38 PM