Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Location of cdc tables Expand / Collapse
Posted Thursday, August 2, 2012 2:35 AM


Group: General Forum Members
Last Login: Yesterday @ 12:11 AM
Points: 499, Visits: 1,551
I configured CDC for one of our databases & enabled some tables. As expected, in SSMS I find the cdc-tables (including the "_CT") under "system tables".

Some time later, one of the other dba's enabled some other tables for cdc. But now the created ("_CT") tables don't appear under "system tables" but under "tables".

The cdc process seems to work well, but I am wondering what caused this behavior (& what are potential consequences).

Anyone any idea?


I found this:

May well have been the cause!
Post #1339009
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse