Enable CDC on DataBase and a Table
EXEC sp_changedbowner 'sa'
GO
EXEC sys.sp_cdc_enable_db
GO
-- Enable on the table level
EXEC sys.sp_cdc_enable_table
@source_schema = N'dbo',
@source_name = N'Customer',
@role_name = NULL,
@filegroup_name = N'Primary',
@supports_net_changes = 0
GO
