The CDC is enabled at database as well as table level. Still, no changes in the CT table.
The CDC is enabled at database as well as table level. Still, no changes in the CT table.
Hi @AshutoshUbale-6931, welcome to Microsoft Q&A forum.
Can you please run below commands and check if CDC is properly enabled?
select is_cdc_enabled,* from sys.databases;
select name,is_tracked_by_cdc from sys.tables;
If it is not enable we can configure it at both database and table level.
After enabling the CD at database level, for enabling the CDC at table level, we must be using below commands:
EXEC sys.sp_cdc_enable_table
@source_schema = N'dbo',
@source_name = N'test',
@role_name = NULL,
@supports_net_changes = 1
After you enable the CDC as mentioned for above table, please check if the CDC instance is created in system tables as shown below:

After this, we can directly query the above table to see all the changes captured or not (by doing some insert/update/delete operations):

Just one query, are you using Azure SQL database for CDC?
Please let me know if this helps or else we can further discuss the same.
If answer helps, you can mark it 'Accept Answer'
Hi @AshutoshUbale-6931, just wanted to follow up on this if you need more details.
We have not heard back from you. Did @anuragsharma-msft's answer solve your issue? If so, please mark as accepted answer. If not, please let us know how we may better assist.
Thanks
Saurabh
8 people are following this question.
What source/target pairs does Azure Database Migration Service currently support?
Migration from IAAS to Hyperscale on Azure
Moving 7TB of data from Azure IAAS database to Hyperscale
List of required allowed services, allowed resource types and allowed permissions for SAS
how to replicate ongoing changes of on prem database to data lake?