Change Data Capture
Change data capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format. The change tables used by change data capture contain columns that mirror the column structure of a tracked source table, along with the metadata needed to understand the changes that have occurred.
Change data capture is available only on the Enterprise, Developer, and Evaluation editions of SQL Server.
The following topics contain reference information about the stored procedures, tables, and functions used with change data capture.
|
Topic |
Description |
|---|---|
|
Describes the stored procedures provided for use with change data capture, including the procedures used to enable change data capture on databases and tables. |
|
|
Change Data Capture Related Dynamic Management Views (Transact-SQL) |
Describes the views for displaying information about change data capture transactions and log sessions. |
|
Describes the tables in which the change data and metadata is stored. |
|
|
Describes the functions provided to query the change data, including functions for retrieving changes and for mapping between datetime values and log sequence numbers. |
- 8/4/2011
- Detroitselvam
TFL: Thank you for your feedback. For these kinds of questions, please try the following forums:IIS: http://forums.iis.net/Microsoft
Answers: http://social.answers.microsoft.com/Forums/en
- 4/7/2011
- Rei
- 7/12/2011
- Thomas Lee
I am familiar with Change Data Capture in sqlserver 2008 but my question is
How we can know exactly who made changes ?
thanks
TFL: Thank you for your feedback. For these kinds of questions, please try the following forums:IIS: http://forums.iis.net/Microsoft
Answers: http://social.answers.microsoft.com/Forums/en
- 5/26/2011
- fayyazi
- 7/12/2011
- Thomas Lee