Change Data Capture Stored Procedures (Transact-SQL)

MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
Transact-SQL Reference
System Stored Procedures (Transact-SQL)

Related Links

Change Data Capture Stored Procedures (Transact-SQL)

SQL Server 2008 Books Online (October 2009)

Change Data Capture Stored Procedures (Transact-SQL)

Change data capture makes available in a convenient relational format the historical record of Data Manipulation Language (DML) activity that occurred on enabled tables. The following stored procedures are used to configure change data capture, manage the change data capture Agent jobs, and supply current meta data to change data consumers.

sys.sp_cdc_add_job (Transact-SQL)	sys.sp_cdc_generate_wrapper_function (Transact-SQL)
sys.sp_cdc_change_job (Transact-SQL)	sys.sp_cdc_get_captured_columns (Transact-SQL)
sys.sp_cdc_cleanup_change_table (Transact-SQL)	sys.sp_cdc_get_ddl_history (Transact-SQL)
sys.sp_cdc_disable_db (Transact-SQL)	sys.sp_cdc_help_change_data_capture (Transact-SQL)
sys.sp_cdc_disable_table (Transact-SQL)	sys.sp_cdc_help_jobs (Transact-SQL)
sys.sp_cdc_drop_job (Transact-SQL)	sys.sp_cdc_scan (Transact-SQL)
sys.sp_cdc_enable_db (Transact-SQL)	sys.sp_cdc_start_job (Transact-SQL)
sys.sp_cdc_enable_table (Transact-SQL)	sys.sp_cdc_stop_job (Transact-SQL)

Other Resources

Change Data Capture Tables (Transact-SQL)
Configuring Change Data Capture

Help and Information

Getting SQL Server 2008 Assistance