This topic has not yet been rated - Rate this topic

Using Change Tracking

SQL Server 2008

Applications that use change tracking must be able to obtain tracked changes, apply these changes to another data store, and update the source database. The topics in this section describe how to perform these tasks, and also the role change tracking plays when a failover occurs and a database must be restored from a backup

In This Section

Obtaining Changes by Using the Change Tracking Functions: Describes how to use the change tracking functions to obtain changes and information about the changes that were made to a database.
How Change Tracking Handles Changes to a Database: Describes how to make changes in a database when change tracking is enabled.
Change Tracking and Data Restore: Provides information about how to use change tracking reliably when a data restore operation occurs.

Reference

CHANGETABLE (Transact-SQL)

CHANGE_TRACKING_MIN_VALID_VERSION (Transact-SQL)

CHANGE_TRACKING_CURRENT_VERSION (Transact-SQL)

WITH CHANGE_TRACKING_CONTEXT (Transact-SQL)

Concepts

Change Tracking Overview

Configuring and Managing Change Tracking

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD