Before you can begin capturing data changes for a table, you must first enable the database for Change Data Capture. You do this by running the stored procedure
sys.sp_cdc_enable_db within the desired database context. When a database is enabled for Change Data Capture, the
CDC user, and metadata tables, as well as the system functions, are used to query for change data.
To determine whether a database is already enabled for CDC, you can check the value in the
is_cdc_enabled column in the
sys.databases catalog view. A value of
1 indicates that CDC is enabled for the specified database.
The following SQL code enables CDC for the
AdventureWorks2012 database and then checks that CDC is enabled by querying ...