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. ...
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...
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...