Microsoft offers two mechanisms for tracking changes: Change Data Capture (CDC) and Change Tracking. CDC is an asynchronous process which captures the exposed data from the Transaction log. It not only captures the fact that data changed but it captures the actual data that changed. It uses the same...