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

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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 5:42 AM
Points: 368, Visits: 1,312
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?

Edit:

I found this: http://yrushka.com/index.php/sql-errors-and-fixes/sql-server-fix-sp_ms_marksystemobject-invalid-object-name-cdc-cdc_table1/

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

Add to briefcase

Permissions Expand / Collapse