• About Me
  • #SQLHelp
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Training
  • Oracle
  • Forum
  • Freelance
  • Disclaimer and copyright
Sql server Blog Forum

Helping SQL server DBAs and Developers

  • About Me
  • #SQLHelp
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Training
  • Oracle
  • Forum
  • Freelance
  • Disclaimer and copyright
  • About Me
  • #SQLHelp
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Training
  • Oracle
  • Forum
  • Freelance
  • Disclaimer and copyright
  • DBA

    Msg 22906, Level 16, State 1, Procedure sp_cdc_enable_db_internal cannot be enabled for Change Data Capture because a database user named cdc

    May 4, 2022

    Overview: There was a database restore from production to UAT and the restore was done without Keep CDC option. When developer asked to enable CDC the following was the error. Always keep CDC while restore is best option whether we have CDC or not. use [DB Name] go exec sys.sp_cdc_enable_db Msg 22906, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 49 [batch start line 2] The database ‘DBName’ cannot be enabled for Change Data Capture because a database user named ‘cdc’ or a schema named ‘cdc’ already exists in the current database. These objects are required exclusively by Change Data Capture. Drop or rename the user or schema and retry the…

    Read More
    Muthukkumaran Kaliyamoorthy No Comments

Search box

Advertisements

Categories

  • AlwaysON
  • AutoMon
  • Azure
  • Backup/Restore
  • Basics for freshers
  • DBA
  • Docker
  • DR/HA
  • Indexes
  • Internals
  • Junior DBA
  • Microsoft
  • Oracle
  • Performance
  • PowerShell
  • Questions
  • Scripts
  • SQL party
  • T-SQL
  • VLDB

Archives

Top SQL server blogs

  • Adam Machanic
  • Amit Banerjee
  • Brent Ozar
  • Gail Shaw
  • Grant Fritchey
  • Paul White
  • Pinal Dave
  • SimpleTalk
  • Sqlblog
  • SQLskills

Top Posts & Pages

  • Login failed for [SQLSTATE 28000] (Error 18456) the step failed
    Login failed for [SQLSTATE 28000] (Error 18456) the step failed
  • The Cluster service failed to bring clustered service or application completely online or offline. One or more resources may be in a failed state.
    The Cluster service failed to bring clustered service or application completely online or offline. One or more resources may be in a failed state.
  • Test connection failed because of an error in initializing provider. Oracle client and networking components were not found
    Test connection failed because of an error in initializing provider. Oracle client and networking components were not found
  • AlwaysON database not synchronizing suspect mode
    AlwaysON database not synchronizing suspect mode
  • How to use Blitz Brent Ozar First Responder Kit
    How to use Blitz Brent Ozar First Responder Kit
  • AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
    AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
  • SQL server daily health check DBA script
    SQL server daily health check DBA script
  • How to find slow running T SQL query
    How to find slow running T SQL query
  • TempDB database is Full and Optimization
    TempDB database is Full and Optimization
  • Patch Update apply and automate SQL server patch for multiple servers patching compliance by DBATools Powershell
    Patch Update apply and automate SQL server patch for multiple servers patching compliance by DBATools Powershell
Savona Theme by Optima Themes