Click here to Skip to main content
15,898,222 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All
I tried to create a CDC enabled Database and performed few DML operations onto it. However upon executing the select * from tables like:-
[cdc].[captured_columns],[cdc].[ddl_history],[cdc].[index_columns],[cdc].[change_tables]

I am not getting any data capture across the columns,no data is being retrieved in the above columns:(

What I have tried:

I tried creating the CDC using the following syntax:-
Exec sys.sp_cdc_enable_db
Exec sys.sp_cdc_enable_table
@source_schema='dbo'
@source_name='CustDetails'
@role_name='Null'
@support_net_changes=1


(But I do have to admit that, i don't remember whether I entered the last line or not!!how do i ensure this??)
Please help me to resolve the problems here!!
Posted
Comments
manishss 24-Jun-16 6:44am    
Is table has data in it?
Firstly check that whether table has data or not
mousau 24-Jun-16 9:51am    
Hi Manish
I guess found the problem, I executed the cdc on table query, when the table was empty,then populated, I just tried disabling everything and populated the table and then executed the commands again! And it worked!!
mousau 24-Jun-16 9:17am    
Hi Manishss
The table has data, but one fact to wonder about is :- cdc.dbo_CustDetails_CT was not created!!!!! A little light on this would be of great relief!!
Regards

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900