Home Microsoft SQL Server DigiMailing Contact
    Keyword



  On Change Data Capture Microsoft SQL Server supplies you with the following objects:

Procedure
  • sys.sp_cdc_add_job
  • sys.sp_cdc_add_job_internal
  • sys.sp_cdc_captured_columns
  • sys.sp_cdc_change_data_capture
  • sys.sp_cdc_change_job
  • sys.sp_cdc_change_job_internal
  • sys.sp_cdc_cleanup_change_table
  • sys.sp_cdc_cleanup_change_tables
  • sys.sp_cdc_cleanup_change_table_internal
  • sys.sp_cdc_cleanup_job_entries
  • sys.sp_cdc_cleanup_job_internal
  • sys.sp_cdc_create_change_enumeration_functions
  • sys.sp_cdc_create_change_enumeration_wrapper_function
  • sys.sp_cdc_create_change_table
  • sys.sp_cdc_create_change_table_index
  • sys.sp_cdc_create_functions
  • sys.sp_cdc_create_objects
  • sys.sp_cdc_create_populate_stored_procs
  • sys.sp_cdc_dbsnapshotLSN
  • sys.sp_cdc_ddl_event_internal
  • sys.sp_cdc_ddl_history
  • sys.sp_cdc_disable_db
  • sys.sp_cdc_disable_db_internal
  • sys.sp_cdc_disable_table
  • sys.sp_cdc_disable_table_instance
  • sys.sp_cdc_disable_table_internal
  • sys.sp_cdc_drop_change_table_objects
  • sys.sp_cdc_drop_job
  • sys.sp_cdc_drop_job_internal
  • sys.sp_cdc_drop_objects
  • sys.sp_cdc_enable_db
  • sys.sp_cdc_enable_db_internal
  • sys.sp_cdc_enable_table
  • sys.sp_cdc_enable_table_internal
  • sys.sp_cdc_extract_column
  • sys.sp_cdc_generate_wrapper_function
  • sys.sp_cdc_generate_wrapper_function_internal
  • sys.sp_cdc_get_captured_columns
  • sys.sp_cdc_get_capture_instances
  • sys.sp_cdc_get_cleanup_retention
  • sys.sp_cdc_get_ddl_history
  • sys.sp_cdc_get_job_parameters
  • sys.sp_cdc_grant_select_on_change_enumeration_functions
  • sys.sp_cdc_help_change_data_capture
  • sys.sp_cdc_help_jobs
  • sys.sp_cdc_help_jobs_internal
  • sys.sp_cdc_logddl_internal
  • sys.sp_cdc_lsn_time_mapping_procs
  • sys.sp_cdc_parse_captured_column_list
  • sys.sp_cdc_parse_included_column_list
  • sys.sp_cdc_parse_update_flag_list
  • sys.sp_cdc_restoredb
  • sys.sp_cdc_restoredb_internal
  • sys.sp_cdc_scan
  • sys.sp_cdc_start_job
  • sys.sp_cdc_start_job_internal
  • sys.sp_cdc_stop_job
  • sys.sp_cdc_stop_job_internal
  • sys.sp_cdc_verify_capture_instance
  • sys.sp_cdc_verify_index_name
  • sys.sp_cdc_verify_role_name
  • sys.sp_cdc_vupgrade
  • sys.sp_cdc_vupgrade_databases
  • sys.sp_MScdc_capture_job
  • sys.sp_MScdc_cleanup_job
  • sys.sp_MScdc_db_ddl_event
  • sys.sp_MScdc_ddl_database_triggers
  • sys.sp_MScdc_ddl_event
  • sys.sp_MScdc_ddl_server_trigger
  • sys.sp_MScdc_job_security_check
  • sys.sp_MScdc_logddl
  • sys.sp_MScdc_tranrepl_check


  • View
  • sys.dm_cdc_errors
  • sys.dm_cdc_log_scan_sessions