change-data-capture-stored-procedures-transact-sql.md

title	Change Data Capture Stored Procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	system stored procedures [SQL Server], change data capture change data capture [SQL Server], stored procedures
ms.assetid	7da7068d-6388-465a-b708-a2f27ded1efe
caps.latest.revision	17
author	BYHAM
ms.author	rickbyh
manager	jhubbard

Change Data Capture Stored Procedures (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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)

See Also

Change Data Capture Tables (Transact-SQL)