Internal tables, inserted and deleted tables, change tracking

  • I understand that change tracking writes changes to "internal tables." Are these in the database that the change tracking is occuring on?

    Do internal tables include inserted and deleted tables (e.g., those that are involved with DML triggers)?

  • I am thinking they will be in TEMPDB

  • Golfer22 (1/1/2013)


    I understand that change tracking writes changes to "internal tables." Are these in the database that the change tracking is occuring on?

    Do internal tables include inserted and deleted tables (e.g., those that are involved with DML triggers)?

    it seems like homework 😉 , anyways here is the link which can give you bright picture of change tracking

    http://www.mssqltips.com/sqlservertip/1819/using-change-tracking-in-sql-server-2008/

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • SatishAyyar (1/1/2013)


    I am thinking they will be in TEMPDB

    i dont think , it should be in same database.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • Golfer22 (1/1/2013)


    I understand that change tracking writes changes to "internal tables." Are these in the database that the change tracking is occuring on?

    The internal change tracking tables reside in the database where changes are being tracked, not in tempdb. This is critical for disaster recovery and high-availability. Change tracking information is included in the backup file when a database is backed up, and when a backup file is restored.

    Do internal tables include inserted and deleted tables (e.g., those that are involved with DML triggers)?

    No, INSERTED and DELETED are virtual, read-only tables that are only present for the duration of a transaction, and are only accessible inside the trigger code. Changes are tracked for user-tables.

    Change Tracking (SQL Server 2008 R2)

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply