Enabling CDC for a Table
When the database is enabled for Change Data Capture, you can use the sys.sp_cdc_enable_table
stored procedure to enable a Change Data Capture instance for any tables in that database. The sp_cdc_enable_Table
stored procedure supports the following parameters:
• @source_schema
—Specifies the name of the schema in which the source table resides.
• @source_name
—Specifies the name of the source table.
• @role_name
—Indicates the name of the database role used to control access to Change Data Capture tables. If this parameter is set to NULL
, no role is used to limit access to the change data. If the specified role does not exist, SQL Server creates a database role with the specified name.
• @capture_instance
—Specifies the ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.