| title | sys.sp_cdc_disable_table (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/15/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | da2156c0-504e-4d76-b9a0-4448becf9bda | ||||
| caps.latest.revision | 27 | ||||
| author | BYHAM | ||||
| ms.author | rickbyh | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Disables change data capture for the specified source table and capture instance in the current database. Change data capture is not available in every edition of [!INCLUDEmsCoName][!INCLUDEssNoVersion]. For a list of features that are supported by the editions of [!INCLUDEssNoVersion], see Features Supported by the Editions of SQL Server 2016.
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
Transact-SQL Syntax Conventions
sys.sp_cdc_disable_table
[ @source_schema = ] 'source_schema' ,
[ @source_name = ] 'source_name'
[ , [ @capture_instance = ] 'capture_instance' | 'all' ]
[ @source_schema= ] 'source_schema'
Is the name of the schema in which the source table is contained. source_schema is sysname, with no default, and cannot be NULL.
source_schema must exist in the current database.
[ @source_name= ] 'source_name'
Is the name of the source table from which change data capture is to be disabled. source_name is sysname, with no default, and cannot be NULL.
source_name must exist in the current database.
[ @capture_instance= ] 'capture_instance' | 'all'
Is the name of the capture instance to disable for the specified source table. capture_instance is sysname and cannot be NULL.
When 'all' is specified, all capture instances defined for source_name are disabled.
0 (success) or 1 (failure)
None
sys.sp_cdc_disable_table drops the change data capture change table and system functions associated with the specified source table and capture instance. It deletes any rows associated with the specified capture instance from the change data capture system tables and sets the is_tracked_by_cdc column for the table entry in the sys.tables catalog view to 0.
Requires membership in the db_owner fixed database role.
The following example disables change data capture for the HumanResources.Employee table.
USE AdventureWorks2012;
GO
EXECUTE sys.sp_cdc_disable_table
@source_schema = N'HumanResources',
@source_name = N'Employee',
@capture_instance = N'HumanResources_Employee';