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 2012 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.
