Change Data Capture stored procedures (Transact-SQL)
Applies to: 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 metadata to change data consumers.
sys.sp_cdc_add_job (Transact-SQL)
sys.sp_cdc_change_job (Transact-SQL)
sys.sp_cdc_cleanup_change_table (Transact-SQL)
sys.sp_cdc_disable_db (Transact-SQL)
sys.sp_cdc_disable_table (Transact-SQL)
sys.sp_cdc_drop_job (Transact-SQL)
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: Under hela 2024 kommer vi att fasa ut GitHub-problem som feedbackmekanism för innehåll och ersätta det med ett nytt feedbacksystem. Mer information finns i:Skicka och visa feedback för