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 ...
Get Microsoft SQL Server 2014 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.