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;-)