Reputation
2,126
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
2 14 32
Newest
 Yearling
Impact
~169k people reached

Apr
23
wiki
Apr
23
suggested approved edit on
Apr
23
suggested approved edit on
Apr
23
asked SQL Server Audit Specification - filter DML by all but one user
Apr
17
awarded  Popular Question
Mar
20
awarded  Notable Question
Feb
12
awarded  Popular Question
Feb
4
awarded  Custodian
Feb
4
reviewed Reject What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
Nov
5
awarded  Notable Question
Nov
3
comment Change data capture - how to know who made the change?
Ahhhh, didn't catch that. I get what your saying now.
Nov
1
comment Change data capture - how to know who made the change?
That only gets you the svc account/owner of cdc, you might note that I tried those things and documented the results in my original question way back in Feb.
Oct
19
revised Create table from stored procedure result
added 395 characters in body
Oct
19
answered Create table from stored procedure result
Oct
19
revised Does SQL manage foreign key constraints in terms of Insertion?
added 8 characters in body
Oct
14
revised Doing a point in time restore with CDC enabled; Possible?
added 7 characters in body
Oct
4
awarded  Enlightened
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
We've been running CDC on an async mirror for several months. It's been working great for tbe data warehouse to query the snapshot. It wasn't until we moved the mirror partner to a new datacenter that all this became an issue. Setting up mirror and then CDC, no problem. CDC and then mirroring... not so easy.
Oct
4
awarded  Nice Answer
Oct
4
accepted Doing a point in time restore with CDC enabled; Possible?