We ran into an issue when patching our CE v9. A table couldn't be truncated due to cdc-enabled. See error message below.
"Microsoft.Crm.CrmException: Error in Action: Bin\Microsoft.Crm.Setup.DiffBuilder.dll:UpdateMetadataForMetadata on attempt 3. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Cannot truncate table 'MetadataForMetadata' because it is published for replication or enabled for Change Data Capture."
After discussed our situation with MS support, they couldn't be able to provide us a truncate table list.
Here what I'm asking is - is it possible for your dev team to consider to replace truncate command in the code, using delete instead?
At least this will make our life much easier later.