How to check if SQL Server CDC is working and getting the right data

what (question)? how can one check if their sql server cdc configuration is working on their source database? where? any sql server database where cdc is turned on and your sql server source most likely you are trying to ensure that changes from your source connector that uses cdc as the incremental update configuration are accurately synchronizing to your target how (answer)? some basic nuances about sql server cdc can still confuse even seasoned dbas here are a few items that may cause confusion but should be checked here are a few steps that we recommend you follow to get aligned with how data is flowing from your sql server cdc enabled tables to the target if there are still questions or if assistance is needed let us know in dlh io run a historical re sync on this table to complete the operation who? your sql server database administrator (dba) is best suited for the job use your support credits with us by contacting your engagement manager or using the support portal when? incorporate the instruction in the answer above anytime you seem to be missing a column in the target where your dba has confirmed that the table in question is using the cdc (not change tracking) method dlh io will pass alerts if the final synchronization to the target destination table fails because of this or the retrieval of data cannot be accomplished because of this microsoft sql server feature of their cdc configuration