April 25, 2013 at 5:04 pm
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.
April 25, 2013 at 5:46 pm
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?
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 25, 2013 at 9:54 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply