• And what is up with not being able to reindex a CDC-enabled table?

    I'm a bit puzzled by this. I have CDC enabled tables and I can both rebuild and reorganise the indexes on them. I guess it depends how you perform reindexing. CDC does not let you drop the existing PK as it is used for CDC. If your reindexing scripts go through and actually drop and recreate indexes then this will not work with CDC enabled tables (same applies for transactional replication for that matter), but that is no longer a recommended method to rebuild indexes. However if you use "alter index rebuild/reorganize" functionality this works without an issue with CDC enabled. Maybe I'm missing something though.

    Cheers

    Roddy