Skip to content

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

Latest commit

 

History

History
65 lines (46 loc) · 3.71 KB

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

File metadata and controls

65 lines (46 loc) · 3.71 KB
description Change Data Capture Stored Procedures (Transact-SQL)
title Change Data Capture Stored Procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology system-objects
ms.topic 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
author markingmyname
ms.author maghan

Change Data Capture Stored Procedures (Transact-SQL)

[!INCLUDE SQL Server]

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.

:::row::: :::column::: sys.sp_cdc_add_job (Transact-SQL)

    [sys.sp_cdc_change_job (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-change-job-transact-sql.md)

    [sys.sp_cdc_cleanup_change_table (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-cleanup-change-table-transact-sql.md)

    [sys.sp_cdc_disable_db (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-disable-db-transact-sql.md)

    [sys.sp_cdc_disable_table (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-disable-table-transact-sql.md)

    [sys.sp_cdc_drop_job (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-drop-job-transact-sql.md)

    [sys.sp_cdc_enable_db (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-enable-db-transact-sql.md)

    [sys.sp_cdc_enable_table (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-enable-table-transact-sql.md)
:::column-end:::
:::column:::
    [sys.sp_cdc_generate_wrapper_function (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-generate-wrapper-function-transact-sql.md)

    [sys.sp_cdc_get_captured_columns (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-get-captured-columns-transact-sql.md)

    [sys.sp_cdc_get_ddl_history (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-get-ddl-history-transact-sql.md)

    [sys.sp_cdc_help_change_data_capture (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-help-change-data-capture-transact-sql.md)

    [sys.sp_cdc_help_jobs (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-help-jobs-transact-sql.md)

    [sys.sp_cdc_scan (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-scan-transact-sql.md)

    [sys.sp_cdc_start_job (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-start-job-transact-sql.md)

    [sys.sp_cdc_stop_job (Transact-SQL)](../../relational-databases/system-stored-procedures/sys-sp-cdc-stop-job-transact-sql.md)
:::column-end:::

:::row-end:::

See Also

Change Data Capture Tables (Transact-SQL)