Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 R2 - CDC or Trigger Expand / Collapse
Author
Message
Posted Tuesday, January 08, 2013 3:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:40 PM
Points: 159, Visits: 454
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 ?
Post #1404462
Posted Wednesday, January 09, 2013 12:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:52 AM
Points: 2,820, Visits: 3,917
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
Post #1404574
Posted Wednesday, January 09, 2013 1:17 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:40 PM
Points: 159, Visits: 454
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.
Post #1404970
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse