SQL Server 2016 articles, fixes and updates - Year 2023

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2016 that have been released in Year 2023. The list is daily updated.

• 3009974 FIX: Slow synchronization when disks have different sector sizes for primary and secondary replica log files in SQL Server AG and Logshipping environments Q3009974 KB3009974 December 25, 2023
• 4470057 FIX: Error 41168 occurs when you try to alter DAG SEEDING_MODE in SQL Server 2016 and 2017 Q4470057 KB4470057 November 10, 2023
• 4464106 Cumulative Update 4 for SQL Server 2016 SP2 Q4464106 KB4464106 October 25, 2023
• 4013106 Cumulative Update 2 for SQL Server 2016 SP1 Q4013106 KB4013106 October 24, 2023
• 4495256 Cumulative Update 7 for SQL Server 2016 SP2 Q4495256 KB4495256 October 23, 2023
• 4488536 Cumulative Update 6 for SQL Server 2016 SP2 Q4488536 KB4488536 October 23, 2023
• 4475776 Cumulative Update 5 for SQL Server 2016 SP2 Q4475776 KB4475776 October 23, 2023
• 4458871 Cumulative Update 3 for SQL Server 2016 SP2 Q4458871 KB4458871 October 23, 2023
• 4340355 Cumulative Update 2 for SQL Server 2016 SP2 Q4340355 KB4340355 October 23, 2023
• 4135048 Cumulative Update 1 for SQL Server 2016 SP2 Q4135048 KB4135048 October 23, 2023
• 4052908 SQL Server 2016 Service Pack 2 release information Q4052908 KB4052908 October 23, 2023
• 4040714 Cumulative Update 5 for SQL Server 2016 SP1 Q4040714 KB4040714 October 23, 2023
• 4037354 Cumulative Update 6 for SQL Server 2016 SP1 Q4037354 KB4037354 October 23, 2023
• 4024305 Cumulative Update 4 for SQL Server 2016 SP1 Q4024305 KB4024305 October 23, 2023
• 4019916 Cumulative Update 3 for SQL Server 2016 SP1 Q4019916 KB4019916 October 23, 2023
• 4501205 FIX: "Non-yielding Scheduler" occurs when you clean up in-memory runtime statistics of Query Store in SQL Server 2016 Q4501205 KB4501205 October 20, 2023
• 4134601 FIX: "Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClientUI'" error when a "Process Full" operation is run in SQL Server Q4134601 KB4134601 October 20, 2023
• 3182270 Cumulative Update 2 for SQL Server 2016 Q3182270 KB3182270 October 20, 2023
• 3174812 FIX: Queries on Stretch Database enabled databases always involve a network round-trip to Azure in SQL Server 2016 Q3174812 KB3174812 October 20, 2023
• 3164674 Cumulative Update 1 for SQL Server 2016 Q3164674 KB3164674 October 20, 2023
• 3182545 SQL Server 2016 Service Pack 1 release information Q3182545 KB3182545 October 18, 2023
• 5029187 Description of the security update for SQL Server 2016 SP3 Azure Connect Feature Pack: October 10, 2023 Q5029187 KB5029187 October 10, 2023
• 5029186 Description of the security update for SQL Server 2016 SP3 GDR: October 10, 2023 Q5029186 KB5029186 October 10, 2023
• 4035062 FIX: Memory use with many databases in SQL Server 2017 or 2016 is greater than in earlier versions Q4035062 KB4035062 August 29, 2023
• 4052134 FIX: Errors 33111 and 3013 when backing up TDE-encrypted database in SQL Server Q4052134 KB4052134 August 28, 2023
• 4024563 FIX: Unhandled exception when you export an SSRS report to a .pdf file if the page height is set to 8.5 inches in SQL Server 2014 or 2016 Q4024563 KB4024563 August 28, 2023
• 4021580 FIX: System generated stored procedures are created incorrectly in P2P publication if the schema name of published table contains a period (.) in SQL Server 2014 or 2016 Q4021580 KB4021580 August 28, 2023
• 4019799 FIX: Deadlock when you run the "CleanOrphanedPolicies" and "DeleteDataSources" built-in stored procedures together in SSRS 2016 Q4019799 KB4019799 August 28, 2023
• 4019701 FIX: Database schema is corrupted when you restore a database from a snapshot in SQL Server Q4019701 KB4019701 August 28, 2023
• 4015561 FIX: Access violation when a stored procedure is dropped before you execute END TRY section in SQL Server Q4015561 KB4015561 August 28, 2023
• 4015034 FIX: An assertion occurs when you run an UPDATE statement on a clustered columnstore index in SQL Server 2016 Q4015034 KB4015034 August 28, 2023
• 4014732 FIX: A memory leak in SQLWEP causes the host process Wmiprvse.exe to crash in SQL Server Q4014732 KB4014732 August 28, 2023
• 4013883 FIX: Data type conversion error due to late evaluation of a filter predicate in a query involving a column store index in SQL Server 2016 Q4013883 KB4013883 August 28, 2023
• 3196877 FIX: Incremental statistics run with higher sample rate than regular statistics when statistics are created or updated in SQL Server 2014 or 2016 Q3196877 KB3196877 August 28, 2023
• 3194959 Statistics are removed after rebuilding a specific partition of a partitioned aligned index on a partitioned table in SQL Server Q3194959 KB3194959 August 28, 2023
• 3190761 Update to improve diagnostics by exposing data type of the parameters for parameterized queries in showplan XML output in SQL Server 2016 Q3190761 KB3190761 August 28, 2023
• 3205413 Cumulative update 3 for SQL Server 2016 Q3205413 KB3205413 August 22, 2023
• 3185650 FIX: Access violation occurs when you execute a query that contains many COUNT DISTINCT operations in SQL Server 2016 Q3185650 KB3185650 August 21, 2023
• 3180087 Poor performance when you run INSERT.. SELECT operations in SQL Server 2016 or SQL Server 2017 on Windows Q3180087 KB3180087 August 21, 2023
• 3175205 FIX: Long query that contains specific expressions receives syntax error if forced parameterization is enabled in SQL Server 2016 Q3175205 KB3175205 August 21, 2023
• 3171469 Cannot open an SSRS paginated report from SQL Server 2016 Reporting Services web portal on an iPad Q3171469 KB3171469 August 21, 2023
• 3170132 FIX: Error 7330 when you query the view that is created by the Data Feed Publishing Wizard in SQL Server 2016 Q3170132 KB3170132 August 21, 2023
• 3170077 FIX: JavaScript error when you create an MDS subscription view in SQL Server 2016 Q3170077 KB3170077 August 21, 2023
• 2953354 FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server Q2953354 KB2953354 August 21, 2023
• 5016729 Improvement: Enable distributed availability groups on SQL Server Standard editions with Azure services Q5016729 KB5016729 August 7, 2023
• 4092997 FIX: VC++ 2015 Redistributable installation returns error 1638 when a newer version is already installed Q4092997 KB4092997 August 2, 2023
• 4056955 FIX: Queries that cast string or binary data to XML take a long time to compile in SQL Server 2016 and 2017 Q4056955 KB4056955 August 2, 2023
• 4052572 FIX: SSAS 2016 and 2017 crash intermittently when you rename a multidimensional database by using script Q4052572 KB4052572 August 2, 2023
• 4034789 FIX: An unexpected exception error occurs when an XIRR measure processes too many records in SSAS 2016 or 2017 Q4034789 KB4034789 August 2, 2023
• 4046918 FIX: Execution fails when a SQL CLR function invokes Transact-SQL statements through impersonation calls in SQL Server 2016 and 2017 Q4046918 KB4046918 July 24, 2023
• 4040108 FIX: Backup of availability database via VSS-based application may fail in SQL Server Q4040108 KB4040108 July 24, 2023
• 4039284 Enhancement: New keyword is added to CREATE and UPDATE STATISTICS statements to persist sampling rate for future statistics updates in SQL Server Q4039284 KB4039284 July 24, 2023
• 4043624 FIX: Change tracking manual cleanup fails with table non-existence error in SQL Server Q4043624 KB4043624 July 21, 2023
• 4043478 FIX: Error when you export an SSRS report on an iOS device in SQL Server 2016 or 2017 Q4043478 KB4043478 July 21, 2023
• 4040535 FIX: SQL Server Managed Backups do not run a scheduled log backup in SQL Server 2016 or 2017 Q4040535 KB4040535 July 21, 2023
• 4040533 FIX: Returns incorrect results when computed column is queried after installing hotfix that's described in KB 3213683 and enabling TF 176 in SQL Server 2016 or 2017 Q4040533 KB4040533 July 21, 2023
• 4040531 FIX: Constraint violation error returned by the managed_backup.fn_available_backups function after you install the Cumulative Update 2 for SQL Server 2016 SP1 Q4040531 KB4040531 July 21, 2023
• 4040530 FIX: Log chain break in the "managed_backup.fn_available_backups" table in SQL Server 2016 or 2017 Q4040530 KB4040530 July 21, 2023
• 4040519 FIX: Automatic seeding in Availability Groups randomly causes error 41169 in SQL Server 2016 or 2017 Q4040519 KB4040519 July 21, 2023
• 4040512 FIX: Error when exporting a Reporting Services report to PDF in SQL Server 2016 or 2017 Q4040512 KB4040512 July 21, 2023
• 4040376 FIX: Managed Backup to Microsoft Azure stops after large database backup in SQL Server Q4040376 KB4040376 July 21, 2023
• 4040276 FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 and 2017 Q4040276 KB4040276 July 21, 2023
• 4040085 FIX: "Ambiguous paths" error when deploying tabular model database to Analysis Services in SQL Server 2016 or 2017 Q4040085 KB4040085 July 21, 2023
• 4039511 FIX: Managed Backup fails intermittently because of SQLVDI error in SQL Server Q4039511 KB4039511 July 21, 2023
• 4039510 FIX: Access violation occurs when you use sp_xml_preparedocument to open XML documents in SQL Server Q4039510 KB4039510 July 21, 2023
• 4039126 FIX: Horizontal scroll bar missing from Subscription page in SSRS 2016 or 2017 web portal Q4039126 KB4039126 July 21, 2023
• 4039125 FIX: "The folder ... does not exist" error when deleting a folder in web portal of SQL Server 2016 or 2017 Reporting Service Q4039125 KB4039125 July 21, 2023
• 4039124 FIX: Memory spike in LSASS.EXE when you enable Basic Authentication mode in SSRS 2016 or 2017 Q4039124 KB4039124 July 21, 2023
• 4039089 FIX: EXCEPTION_ACCESS_VIOLATION error when you execute the sys.sp_MScdc_capture_job stored procedure in SQL Server Q4039089 KB4039089 July 21, 2023
• 4039058 FIX: Report Viewer Web Part does not allow a full vertical scrollbar after you set a specific web part height Q4039058 KB4039058 July 21, 2023
• 4038882 FIX: SQL Server Managed Backup does not delete old backups that are beyond the retention period in SQL Server Q4038882 KB4038882 July 21, 2023
• 4038113 FIX: EXCEPTION_ACCESS_VIOLATION for query using sys.dm_os_memory_objects statement in SQL Server Q4038113 KB4038113 July 21, 2023
• 4033789 FIX: A memory leak may occur when you perform Process Update operations in SSAS Q4033789 KB4033789 July 21, 2023
• 4032543 FIX: SSAS crashes when you run a DAX or MDX query in SSAS in Tabular mode Q4032543 KB4032543 July 21, 2023
• 4025402 FIX: Security Bulletin MS16-136 breaks the SSRS data source type in PowerPivot in SQL Server 2017 and SQL Server 2016 Q4025402 KB4025402 July 21, 2023
• 4025020 FIX: SUSER_SNAME function returns different results between SQL Server 2014 and SQL Server 2016 or 2017 Q4025020 KB4025020 July 21, 2023
• 4024860 Update to improve the performance for columnstore dynamic management views "column_store_row_groups" and "dm_db_column_store_row_group_physical_stats" in SQL Server 2016 or 2017 Q4024860 KB4024860 July 21, 2023
• 4024622 FIX: Couldn't truncate a partition of the partitioned table if it contains an extended or XML index in SQL Server 2016 or 2017 Q4024622 KB4024622 July 21, 2023
• 4024023 FIX: SSAS crashes when you access .vmp files in SQL Server 2017 and SQL Server 2016 Q4024023 KB4024023 July 21, 2023
• 4023995 FIX: A data mask on a floating points column is not applied in SQL Server 2017 and SQL Server 2016 Q4023995 KB4023995 July 21, 2023
• 4023926 FIX: Unable to drop stored procedure execution article from P2P publication in SQL Server Q4023926 KB4023926 July 21, 2023
• 4023865 FIX: Expanding the Entities folder on the Manage Groups page takes a long time in SQL Server MDS Q4023865 KB4023865 July 21, 2023
• 4022895 FIX: Excel crashes when you save a workbook as a PDF file by using the Adobe Acrobat PDFMaker add-in if the MDS add-in for Excel in SQL Server is also installed Q4022895 KB4022895 July 21, 2023
• 4022753 FIX: SSAS crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy Q4022753 KB4022753 July 21, 2023
• 4019840 FIX: Queries against PolyBase external tables return duplicate rows in SQL Server 2016 and 2017 Q4019840 KB4019840 July 21, 2023
• 4018908 FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) Q4018908 KB4018908 July 21, 2023
• 4099919 Transparent Data Encryption added for Log Shipping in SQL Server 2016 and 2017 Q4099919 KB4099919 July 20, 2023
• 4090004 Improvement: Configure SESSION_TIMEOUT value for a Distributed Availability Group replica in SQL Server 2016 and 2017 Q4090004 KB4090004 July 20, 2023
• 4042251 FIX: Database mirroring failover fails with error 3456 in SQL Server 2016 or 2017 Q4042251 KB4042251 July 20, 2023
• 4039966 FIX: Access violation occurs when a DDL trigger is raised by the CREATE EXTERNAL TABLE command in SQL Server 2016 or 2017 Q4039966 KB4039966 July 20, 2023
• 4039868 FIX: Performance drop when using In-Memory OLTP with Always On availability groups in SQL Server 2016 or 2017 Q4039868 KB4039868 July 20, 2023
• 4039776 FIX: Incorrect behavior when you use memory-optimized tables with "where exists" statement in SQL Server 2016 or 2017 Q4039776 KB4039776 July 20, 2023
• 4039736 FIX: SSIS package does not start when it's run by a CLR stored procedure whose user does not have SYSADMIN permissions Q4039736 KB4039736 July 20, 2023
• 4039509 FIX: SSAS crashes when you process an SSAS database or cube in SQL Server Q4039509 KB4039509 July 20, 2023
• 4038590 FIX: SSIS package that contains German umlauts fails on execution after Incremental Package Deployment in SQL Server 2016 or 2017 Q4038590 KB4038590 July 20, 2023
• 4024393 FIX: Assertion error occurs on the secondary replica when you resume a suspended availability database in SQL Server 2016 or 2017 Q4024393 KB4024393 July 20, 2023
• 4022483 FIX: Error when you export a DQS knowledge base that contains domains in the DQS client in SQL Server Q4022483 KB4022483 July 20, 2023
• 3208545 FIX: SQL Server 2016 or 2017 Analysis Services may crash in a specific situation Q3208545 KB3208545 July 20, 2023
• 4316858 FIX: "Corrupted index" message and server disconnection when an update statistics query uses hash aggregate on SQL Server Q4316858 KB4316858 July 19, 2023
• 4164562 FIX: Wrong user name appears when two users log on to MDS at different times in SQL Server Q4164562 KB4164562 July 19, 2023
• 4163087 FIX: Performance is slow for an Always On AG when you process a read query in SQL Server Q4163087 KB4163087 July 19, 2023
• 4131960 FIX: Access violation when you run a nested select query against a columnstore index in SQL Server Q4131960 KB4131960 July 19, 2023
• 4100582 FIX: Sensitive data may be exposed when you enable DDM function in SQL Server 2016 and 2017 Q4100582 KB4100582 July 19, 2023
• 4094706 FIX: Parallel query hangs when a worker thread is aborted in an instance of SQL Server Q4094706 KB4094706 July 19, 2023
• 4511593 FIX: DBCC SHOW_STATISTICS permission check fails with an AV error in SQL Server 2016 and 2017 Q4511593 KB4511593 July 18, 2023
• 4493364 FIX: Error occurs when you back up a virtual machine with non-component based backup in SQL Server 2016 and 2017 Q4493364 KB4493364 July 18, 2023
• 4459220 FIX: Incorrect results occur when you convert "pollinginterval" parameter from seconds to hours in sys.sp_cdc_scan in SQL Server Q4459220 KB4459220 July 18, 2023
• 4458316 FIX: "Internal error: An unexpected error occurred" when you run an MDX query that was generated by Excel in SSAS Q4458316 KB4458316 July 18, 2023
• 5000715 FIX: Failures with log reader agent occur when you create and drop publication on CDC-enabled database in SQL Server 2019, 2017 or 2016 Q5000715 KB5000715 June 20, 2023
• 3177312 SQL Server 2016 build versions Q3177312 KB3177312 May 4, 2023
• 4575940 FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server Q4575940 KB4575940 April 26, 2023
• 5003279 SQL Server 2016 Service Pack 3 release information Q5003279 KB5003279 March 6, 2023
• 957826 Where to find information about the latest SQL Server builds Q957826 KB957826 February 23, 2023
• 5021129 Description of the security update for SQL Server 2016 SP3 GDR: February 14, 2023 Q5021129 KB5021129 February 21, 2023
• 5021128 Description of the security update for SQL Server 2016 SP3 Azure Connect Feature Pack: February 14, 2023 Q5021128 KB5021128 February 21, 2023
• 4521739 FIX: Error occurs when CDC capture process tries to insert duplicate key in table "cdc.lsn_time_mapping" in SQL Server 2016, 2017 and 2019 Q4521739 KB4521739 January 11, 2023