Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2014-11-19 : 13:03:40
|
| How do you SQL profile CDC activities?I tried and it doesn't display anything on SQL Profiler.Is there a specific event I should select? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-19 : 14:47:37
|
| What do you mean by CDC?Some possibilties:Cult of the Dead CowCalifornia Department of CorrectionsCommunicable Disease CentreCombat Direction CenterCroatian Defense Council... and many, many others |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-11-19 : 15:04:12
|
| If I recall correctly, the CDC stuff happens in the resource database which is not visible in Profiler. Maybe through DAC? Hmmm, can you run Profiler via a DAC connection?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-11-19 : 15:04:51
|
quote:
Originally posted by gbritton
What do you mean by CDC?Some possibilties:Cult of the Dead CowCalifornia Department of CorrectionsCommunicable Disease CentreCombat Direction CenterCroatian Defense Council... and many, many others
The SQL Server Change Data Capture feature - aka CDCTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2014-11-28 : 19:04:54
|
quote:
Originally posted by gbritton
What do you mean by CDC?Some possibilties:Cult of the Dead CowCalifornia Department of CorrectionsCommunicable Disease CentreCombat Direction CenterCroatian Defense Council... and many, many others
LOLChange data Capture. |
|
|
|
|
|
|
profile CDC