How to change the retention period for CDC or put a condition on it (SQL Server 2012)

sql-server,cdc,change-tracking,change-data-capture

sys.sp_cdc_change_job is what you're looking for to change the retention. As to your second question, there is no way for CDC to know what rows you've processed and not. So, you have to set your retention period such that you have enough time to process the records that have accumulated...

Change Data Capture Tracking all changes in fields even though its assigned for only few fields in Dynamics ax table

sql,axapta,dynamics-ax-2012,cdc,change-data-capture

The field ModifiedBy is updated by the system each time a record is updated, irrespective which field is changed. So you must either: stop the data capture of the field ModifiedBy or: create your own field which is updated when the 5 fields are updated, say SomeFieldsModifiedBy The update of...

How to know which column's value is changed in CDC

sql,sql-server,database,change-data-capture

I think what you're looking for is column tracking. You'll need to utilize the CHANGETABLE function to get what you want. Column tracking information appears in the SYS_CHANGE_COLUMNS column that is returned by the CHANGETABLE(CHANGES …) function. Check out this MSDN article for more information. ...