According to BOL the default CDC retention time is 3 days and it was mentioned that it configurable.
Can some of point me on how to change the default value.
Thanks in advance.
You can use sp_cdc_add_job or sp_cdc_change_job to set the retention for the cleanup job.
Thanks
