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