InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 01:22:22 GMT20http://www.sqlservercentral.com/Forums/Topic1404462-146-1.aspxThanks Bhuvnesh, after reading http://technet.microsoft.com/en-us/magazine/2008.11.sql.aspx?pr=blog, I realized that both Change Tracking and Change Data Capture suck. Will rather use Trigger to collect changes to certain column/s in a table.Wed, 09 Jan 2013 13:17:24 GMTkevin_nikolaihttp://www.sqlservercentral.com/Forums/Topic1404462-146-1.aspx[quote][b]kevin_nikolai (1/8/2013)[/b][hr]Both a trigger and cdc (change data capture) can be enabled to monitor changes to a table. When would you use each of them, which is best ?[/quote] see this [url]http://technet.microsoft.com/en-us/magazine/2008.11.sql.aspx?pr=blog[/url]Wed, 09 Jan 2013 00:57:16 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1404462-146-1.aspxBoth a trigger and cdc (change data capture) can be enabled to monitor changes to a table. When would you use each of them, which is best ?Tue, 08 Jan 2013 15:18:41 GMTkevin_nikolai