Change Data Capture vs Change Tracking https://technet.microsoft.com/en-us/library/cc280519%28v=sql.105%29.aspx http://blogs.technet.com/b/josebda/archive/2009/03/24/sql-server-2008-change-tracking-ct-and-change-data-capture-cdc.aspx