Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes. With change tracking integrated into SQL Server, complicated custom change tracking solutions no longer have to be developed.
Change tracking is an important building block for applications that synchronize and replicate data in scenarios in which end-to-end replication solutions do not work and a custom solution is required. For example, a scenario that requires synchronizing data with data stores that are not SQL Server databases or in which the store schemas are very different.
Obtains tracking information for all changes to a table that have occurred since a specified version or the latest change tracking information for a specified row.
Obtains the minimum version that is valid for use in obtaining change tracking information from the specified table when you are using the CHANGETABLE function.
Obtains a version that is associated with the last committed transaction. You can use this version the next time that you enumerate changes by using CHANGETABLE.
Interprets the SYS_CHANGE_COLUMNS value that is returned by the CHANGETABLE(CHANGES …) function.
Enables the specification of a change context, such as an originator ID, when an application changes data.