Database Admin RequiredYou need sysadmin or db_owner privileges to perform these steps.
1. Enable SQL Server Agent
Ensure SQL Server Agent is running. CDC uses agent jobs for cleanup.2. Enable CDC on the database
USE your_database;
EXEC sys.sp_cdc_enable_db;
3. Enable CDC on tables
For each table you want to capture:EXEC sys.sp_cdc_enable_table
@source_schema = N'dbo',
@source_name = N'your_table',
@role_name = NULL,
@supports_net_changes = 1;
4. Grant permissions
The user needs db_datareader and access to the CDC schema:GRANT SELECT ON SCHEMA::cdc TO mantrixflow;
