January 1, 2013 at 9:41 pm
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)?
January 1, 2013 at 10:20 pm
I am thinking they will be in TEMPDB
January 1, 2013 at 11:39 pm
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;-)
January 1, 2013 at 11:40 pm
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;-)
January 2, 2013 at 10:38 am
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