I'm trying to enable Change Data Capture on a table with a clustered columnstore index, a unique non-clustered index, and a non-unique non-clustered index in SQL Server Standard 2019. The command fails with this error:
Msg 35353, Level 16, State 1, Procedure sys.sp_cdc_enable_table_internal,
Line 243 [Batch Start Line 16]
Change Data Capture cannot be enabled on a table with a clustered columnstore index.
Consider dropping clustered columnstore index
I don't understand why I'm getting this error since, as far as I can tell from Microsoft documentation, CDC is supported for CCIs.
Has anyone else run into this error or know why it's occurring?