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

How can we avoid before changes inserts into CDC Tables in SQL Server Expand / Collapse
Author
Message
Posted Thursday, April 25, 2013 5:04 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 4:30 AM
Points: 219, Visits: 689
HI All,
As you all know we have 1 insert in CDC Table for respective insert operation in base table.
2 inserts in CDC table for respective update operation in base table.

1 = delete
2 = insert
3 = update (old values)
4 = update (new values)

can we avoid 3 = update (old values) in CDC tables? Is there a way? I was just curious.
Post #1446750
Posted Thursday, April 25, 2013 5:46 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:56 PM
Points: 6,250, Visits: 7,408
When you say update (old values), I assume you mean setting a field to the exact same value via UPDATE still ending up in CDC2?

And just confirming, you're using the built in CDC, not something homegrown or third party?



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1446756
Posted Thursday, April 25, 2013 9:54 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 4:30 AM
Points: 219, Visits: 689
Hi.thank for response.

Yes, we are using built in CDC mechanism in SQL Server 2008. i just wanted to know if i can do only 1 insert into CDC Tables for respective update in Base table.
Post #1446785
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse