Explanation:If either a schema or a database user named cdc currently exists in a database, the database cannot be enabled for change data capture until the schema and or user are dropped or renamed. 3. Which of the following disable database for Change Data Capture ?
A. EXEC sys.sp_cdc_ensable_db
B. EXEC sys.sp_disable_db
C. EXEC sys.sp_cdc_disable_db
D. All of the mentioned
Answer:A
Explanation:If either a schema or a database user named cdc currently exists in a database, the database cannot be enabled for change data capture until the schema and or user are dropped or renamed. 3. Which of the following disable database for Change Data Capture ?
A. EXEC sys.sp_cdc_ensable_db B. EXEC sys.sp_disable_db C. EXEC sys.sp_cdc_disable_db D. All of the mentioned