1 out of 3 rated this helpful - Rate this topic

Overview of Change Data Capture

SQL Server 2008

SQL Server 2008 R2

Change data capture provides information about DML changes on a table and a database. By using change data capture, you eliminate expensive techniques such as user triggers, timestamp columns, and join queries. This section describes how change data capture works. It also describes the security model.

In This Section

The topics in this section provide an overview of change data capture and its security model.

Basics of Change Data Capture: Describes change data capture data flow, capture instance, change table, change data capture validity interval, and change data capture agent jobs.
Security Model: Provides an overview to the security model for change data capture.

Concepts

Using Change Data

Other Resources

Configuring Change Data Capture

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD