SQL 2008 R2 - CDC or Trigger

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL 2008 R2 - CDC or Trigger

SQL 2008 R2 - CDC or Trigger

Rate Topic

Display Mode

Topic Options

Author

Message

kevin_nikolai

Posted Tuesday, January 08, 2013 3:18 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:19 PM
Points: 141, Visits: 388

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

Bhuvnesh

Posted Wednesday, January 09, 2013 12:57 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1404574

kevin_nikolai

Posted Wednesday, January 09, 2013 1:17 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:19 PM
Points: 141, Visits: 388

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 »

Permissions