Twelve security flaws addressed; CDC column loss remains possible
Addresses 12 Important vulnerabilities in SQL Server 2017. It also introduces a known CDC issue that can leave columns missing and cause capture jobs or applications to fail; a KEEP_CDC restore can report an error near the end even when the database restores successfully.
Check the newer update, KB5046058- CDC capture job might fail if columns are missing in CDC change tables
Key changes 12 CVEs · 3 changes
- Improved Query Execution: Using PREDICT with an incorrect model now gets a validation check to help avoid errors.
- Improved Replication: CDC can block data-definition operations through a new metadata protection capability.
- Fix Temporal: Stored procedures that manage temporal tables correctly quote table and column names in cases where they previously might not.