SQL Server 2017 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 2017 that have been released in Year 2023. The list is daily updated.

• 4470057 FIX: Error 41168 occurs when you try to alter DAG SEEDING_MODE in SQL Server 2016 and 2017 Q4470057 KB4470057 November 10, 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
• 5029376 Description of the security update for SQL Server 2017 CU31: October 10, 2023 Q5029376 KB5029376 October 10, 2023
• 5029375 Description of the security update for SQL Server 2017 GDR: October 10, 2023 Q5029375 KB5029375 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
• 3180087 Poor performance when you run INSERT.. SELECT operations in SQL Server 2016 or SQL Server 2017 on Windows Q3180087 KB3180087 August 21, 2023
• 4508218 Cumulative Update 16 for SQL Server 2017 Q4508218 KB4508218 August 2, 2023
• 4502532 FIX: Query takes a long time if you enable Batch Mode Adaptive Join in SQL Server 2017 Q4502532 KB4502532 August 2, 2023
• 4338296 FIX: Memory leak after dropping a LOB or off-row column from a memory-optimized table in SQL Server on Linux Q4338296 KB4338296 August 2, 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
• 4046065 FIX: Memory corruption occurs during Availability Group failovers for DTC transactions in SQL Server 2017 Q4046065 KB4046065 July 21, 2023
• 4046055 FIX: FORCE_LAST_GOOD_PLAN recommendation stuck at "Verifying" at first verification in SQL Server 2017 Q4046055 KB4046055 July 21, 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
• 5003830 Cumulative Update 25 for SQL Server 2017 Q5003830 KB5003830 May 19, 2023
• 5001228 Cumulative Update 24 for SQL Server 2017 Q5001228 KB5001228 May 19, 2023
• 4047329 SQL Server 2017 build versions Q4047329 KB4047329 May 17, 2023
• 4575940 FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server Q4575940 KB4575940 April 26, 2023
• 957826 Where to find information about the latest SQL Server builds Q957826 KB957826 February 23, 2023
• 5014553 Description of the security update for SQL Server 2017 CU29: June 14, 2022 Q5014553 KB5014553 February 22, 2023
• 5021127 Description of the security update for SQL Server 2017 GDR: February 14, 2023 Q5021127 KB5021127 February 21, 2023
• 5021126 Description of the security update for SQL Server 2017 CU31: February 14, 2023 Q5021126 KB5021126 February 21, 2023
• 5016884 Cumulative Update 31 for SQL Server 2017 Q5016884 KB5016884 February 21, 2023
• 5013756 Cumulative Update 30 for SQL Server 2017 Q5013756 KB5013756 February 21, 2023
• 5010786 Cumulative Update 29 for SQL Server 2017 Q5010786 KB5010786 February 21, 2023
• 5008084 Cumulative Update 28 for SQL Server 2017 Q5008084 KB5008084 February 21, 2023
• 5006944 Cumulative Update 27 for SQL Server 2017 Q5006944 KB5006944 February 21, 2023
• 5005226 Cumulative Update 26 for SQL Server 2017 Q5005226 KB5005226 February 21, 2023
• 5000685 Cumulative Update 23 for SQL Server 2017 Q5000685 KB5000685 February 21, 2023
• 4577467 Cumulative Update 22 for SQL Server 2017 Q4577467 KB4577467 February 21, 2023
• 4557397 Cumulative Update 21 for SQL Server 2017 Q4557397 KB4557397 February 21, 2023
• 4541283 Cumulative Update 20 for SQL Server 2017 Q4541283 KB4541283 February 21, 2023
• 4535007 Cumulative Update 19 for SQL Server 2017 Q4535007 KB4535007 February 21, 2023
• 4527377 Cumulative Update 18 for SQL Server 2017 Q4527377 KB4527377 February 21, 2023
• 4515579 Cumulative Update 17 for SQL Server 2017 Q4515579 KB4515579 February 21, 2023
• 4498951 Cumulative Update 15 for SQL Server 2017 Q4498951 KB4498951 February 21, 2023
• 4484710 Cumulative Update 14 for SQL Server 2017 Q4484710 KB4484710 February 21, 2023
• 4466404 Cumulative Update 13 for SQL Server 2017 Q4466404 KB4466404 February 21, 2023
• 4464082 Cumulative Update 12 for SQL Server 2017 Q4464082 KB4464082 February 21, 2023
• 4462262 Cumulative Update 11 for SQL Server 2017 Q4462262 KB4462262 February 21, 2023
• 4342123 Cumulative Update 10 for SQL Server 2017 Q4342123 KB4342123 February 21, 2023
• 4341265 Cumulative Update 9 for SQL Server 2017 Q4341265 KB4341265 February 21, 2023
• 4338363 Cumulative Update 8 for SQL Server 2017 Q4338363 KB4338363 February 21, 2023
• 4229789 Cumulative Update 7 for SQL Server 2017 Q4229789 KB4229789 February 21, 2023
• 4101464 Cumulative Update 6 for SQL Server 2017 Q4101464 KB4101464 February 21, 2023
• 4092643 Cumulative Update 5 for SQL Server 2017 Q4092643 KB4092643 February 21, 2023
• 4056498 Cumulative Update 4 for SQL Server 2017 Q4056498 KB4056498 February 21, 2023
• 4052987 Cumulative Update 3 for SQL Server 2017 Q4052987 KB4052987 February 21, 2023
• 4052574 Cumulative Update 2 for SQL Server 2017 Q4052574 KB4052574 February 21, 2023
• 4038634 Cumulative Update 1 for SQL Server 2017 Q4038634 KB4038634 February 21, 2023
• 5018231 FIX: Error 20598 after adding columns that have default constraints as part of the primary key for an existing table and configuring transactional replication Q5018231 KB5018231 February 16, 2023
• 5017788 FIX: ParameterRuntimeValue is missing from the Showplan XML when you use the DMV sys.dm_exec_query_statistics_xml Q5017788 KB5017788 February 16, 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