Multiple tables created in CDC

• DBA_007

  Ten Centuries

  Points: 1180

  More actions

  August 21, 2019 at 5:28 pm

  #3673209

  Hello Team,

  I have enabled CDC for a particular database in SqlServer and enabled it for multiple tables. I see duplicate tables have been created for each of the table that I have enabled CDC. Is it by design or have I done anything wrong in configuration.

  Thanks

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  August 21, 2019 at 5:53 pm

  #3673214

  That would be normal if those tables are in the cdc schema with a _CT appended to the name

  Sue