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 8, 2013 3:18 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, September 29, 2014 3:31 PM
Points: 161, Visits: 461
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 9, 2013 12:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:36 AM
Points: 2,840, Visits: 3,970
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 9, 2013 1:17 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, September 29, 2014 3:31 PM
Points: 161, Visits: 461
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