January 8, 2013 at 3:18 pm
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 ?
January 9, 2013 at 12:57 am
kevin_nikolai (1/8/2013)
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 ?
see this http://technet.microsoft.com/en-us/magazine/2008.11.sql.aspx?pr=blog
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2013 at 1:17 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply