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: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om