How to enable Change Data Capture on one or more Tables

As you know Change data Capture (CDC) feature is applied on table level to any database which having CDC enabled. First you have to enable CDC for database then only for table in the database which needs to be tracked by executing sp_cdc_enable_table with some parameter like schema name and table name that you want to track. If you ...