SQL Server 2014 articles, fixes and updates - Year 2020

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

• 4535305 SQL Server Reporting Services remote code execution vulnerability Q4535305 KB4535305 December 18, 2020
• 4535288 Description of the security update for SQL Server 2014 SP3 CU4: February 11, 2020 Q4535288 KB4535288 December 18, 2020
• 4532095 Description of the security update for SQL Server 2014 SP3 GDR: February 11, 2020 Q4532095 KB4532095 December 18, 2020
• 4505422 Description of the security update for SQL Server 2014 SP3 CU3: July 9, 2019 Q4505422 KB4505422 December 18, 2020
• 4505419 Description of the security update for SQL Server 2014 SP2 CU17: July 9, 2019 Q4505419 KB4505419 December 18, 2020
• 4505218 Description of the security update for SQL Server 2014 SP3 GDR: July 9, 2019 Q4505218 KB4505218 December 18, 2020
• 4505217 Description of the security update for SQL Server 2014 SP2 GDR: July 9, 2019 Q4505217 KB4505217 December 18, 2020
• 4480648 FIX: ObjectPropertyEx returns incorrect row count when there are partitions in a database object Q4480648 KB4480648 December 18, 2020
• 4480647 Update adds improvements and fixes issues when you use an Oracle RAC environment in SQL Server Q4480647 KB4480647 December 18, 2020
• 4480639 FIX: SQL Server service crashes when DBCC CHECKDB runs against a database that has a corrupted partition Q4480639 KB4480639 December 18, 2020
• 4479283 FIX: SQL Server installation fails if one of the remote nodes is unreachable in a cluster Q4479283 KB4479283 December 18, 2020
• 4469942 FIX: Sharing violation when the "sp_cycle_agent_errorlog" stored procedure is run in SQL Server Q4469942 KB4469942 December 18, 2020
• 4469722 FIX: Internal error messages when you update a FILESTREAM tombstone system table in SQL Server Q4469722 KB4469722 December 18, 2020
• 4469268 FIX: I/O error on a BPE file causes buffer time-out in SQL Server Q4469268 KB4469268 December 18, 2020
• 4465867 FIX: "ran out of memory" error when executing a query on a table that has a large full-text index in SQL Server 2014, 2016 and 2017 Q4465867 KB4465867 December 18, 2020
• 4463742 FIX: Access violation for query that uses INSERT INTO … SELECT to insert data into clustered columnstore index Q4463742 KB4463742 December 18, 2020
• 4463320 FIX: Intermittent failures when you back up to Azure storage from SQL Server 2014, 2016 and 2017 Q4463320 KB4463320 December 18, 2020
• 4460116 FIX: Overestimations when using default Cardinality Estimator to query table with many null values Q4460116 KB4460116 December 18, 2020
• 4459981 FIX: Access violation occurs and SSAS crashes when you process an SSAS database in SQL Server 2014, 2016 and 2017 Q4459981 KB4459981 December 18, 2020
• 4456883 FIX: Change Tracking cleanup message 22123 is unexpectedly recorded in the error log file in SQL Server Q4456883 KB4456883 December 18, 2020
• 4346661 FIX: Access violation when you query the sysmembers system table in SQL Server Q4346661 KB4346661 December 18, 2020
• 4340837 FIX: Error 3906 when a hotfix is applied on a server that has a SQL Server database snapshot on a pull subscription database Q4340837 KB4340837 December 18, 2020
• 4338204 FIX: Circular dependency between column names for a calculated table that summarizes the partition query dataset in SQL Server Q4338204 KB4338204 December 18, 2020
• 4294694 FIX: Access violation when you try to access a table when page compression is enabled on the table in SQL Server Q4294694 KB4294694 December 18, 2020
• 4164562 FIX: Wrong user name appears when two users log on to MDS at different times in SQL Server Q4164562 KB4164562 December 18, 2020
• 4135113 FIX: Change tracking record is inconsistent during an update on a table that has a clustered or unique index in SQL Server Q4135113 KB4135113 December 18, 2020
• 4133191 FIX: A memory leak occurs in sqlwepxxx.dll causes the WmiPrvSe.exe process to crash Q4133191 KB4133191 December 18, 2020
• 4132896 Transaction log "full" even when space is available and Autogrowth is enabled in SQL Server Q4132896 KB4132896 December 18, 2020
• 4131251 FIX: Thai characters in SSAS for SQL Server exported to a PDF file are displayed incorrectly Q4131251 KB4131251 December 18, 2020
• 4094893 FIX: Database can't be dropped after its storage is disconnected and reconnected in SQL Server Q4094893 KB4094893 December 18, 2020
• 4094706 FIX: Parallel query hangs when a worker thread is aborted in an instance of SQL Server Q4094706 KB4094706 December 18, 2020
• 4092669 FIX: SQL Server doesn't detect a deadlock condition when you run a merge statement Q4092669 KB4092669 December 18, 2020
• 4089099 FIX: It takes a long time to restore a TDE-encrypted database backup in SQL Server Q4089099 KB4089099 December 18, 2020
• 4087406 FIX: Error 9002 when there is no sufficient disk space for critical log growth in SQL Server 2014, 2016, and 2017 Q4087406 KB4087406 December 18, 2020
• 4086173 FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services Q4086173 KB4086173 December 18, 2020
• 4078055 FIX: AG failover occurs after a latch time-out when you use SQL Server 2014 Q4078055 KB4078055 December 18, 2020
• 4058700 FIX: Intermittent 9004 error when a backup is restored via Standby Mode in SQL Server 2014, 2016, and 2017 Q4058700 KB4058700 December 18, 2020
• 4058565 FIX: Assertion error when executing a stored procedure that references a large object in SQL Server 2014, 2016, and 2017 Q4058565 KB4058565 December 18, 2020
• 4057307 FIX: Multidimensional mode randomly crashes and an access violation occurs in SSAS 2016 or in SSAS 2014 Q4057307 KB4057307 December 18, 2020
• 4057280 FIX: High CPU use when large index is used in a query on a memory-optimized table in SQL Server Q4057280 KB4057280 December 18, 2020
• 4053693 FIX: CDC components in SSIS do not function in SQL Server after a cumulative update is applied Q4053693 KB4053693 December 18, 2020
• 4052633 FIX: SELECT query that uses batch mode hash aggregate operator that counts multiple nullable columns returns bad results in SQL Server Q4052633 KB4052633 December 18, 2020
• 4052127 FIX: Alert Engine reads complete Application event log and sends alerts on old events after Windows is restarted Q4052127 KB4052127 December 18, 2020
• 4045814 FIX: "Message 611" error when you use BULK INSERT or INSERT SELECT to insert data into a clustered columnstore index Q4045814 KB4045814 December 18, 2020
• 4043951 FIX: Warning and incorrect computed column results after applying hotfix 3213683 and trace flag 176 Q4043951 KB4043951 December 18, 2020
• 4040376 FIX: Managed Backup to Microsoft Azure stops after large database backup in SQL Server Q4040376 KB4040376 December 18, 2020
• 4040108 FIX: Backup of availability database via VSS-based application may fail in SQL Server Q4040108 KB4040108 December 18, 2020
• 4039735 FIX: "Non-yielding Scheduler" condition occurs for query with many expressions in SQL Server 2014 and 2016 Q4039735 KB4039735 December 18, 2020
• 4024563 FIX: Unhandled exception when you export a SSRS report to a .pdf file if the page height is set to 8.5 inches in SQL Server 2014 or 2016 Q4024563 KB4024563 December 18, 2020
• 4024184 FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016 Q4024184 KB4024184 December 18, 2020
• 4023679 FIX: Timeout when you back up a large database to URL in SQL Server 2014 or 2016 Q4023679 KB4023679 December 18, 2020
• 4021405 FIX: An access violation occurs when you create an index with page compression in SQL Server Q4021405 KB4021405 December 18, 2020
• 4019983 FIX: "Index was out of range" error when exporting to PDF in a SQL Server Reporting Services report Q4019983 KB4019983 December 18, 2020
• 4019603 FIX: SSAS crashes when an MDX query that refers to parent-child dimensions runs in SQL Server 2014 or 2016 Q4019603 KB4019603 December 18, 2020
• 4019125 FIX: System Center Configuration Manager replication process by using BCP APIs fails when there is a large value in an XML column Q4019125 KB4019125 December 18, 2020
• 4018227 FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server Q4018227 KB4018227 December 18, 2020
• 4017022 FIX: Many HkHostLogCheckpointRecord() messages in SQL Server error log Q4017022 KB4017022 December 18, 2020
• 4016804 FIX: Deadlocks occur in SSISDB when you run multiple SSIS packages in SQL Server 2014 or 2016 Q4016804 KB4016804 December 18, 2020
• 4016238 FIX: DBCC CLONEDATABASE is unsuccessful if the source database has an object originally created in SQL Server 2000 Q4016238 KB4016238 December 18, 2020
• 4014798 Update reduces the execution frequency of the sp_MSsubscription_cleanup stored procedure in SQL Server Q4014798 KB4014798 December 18, 2020
• 4014706 FIX: Failed assertion and many access violation dump files after the sp_replcmds stored procedure is canceled in SQL Server Q4014706 KB4014706 December 18, 2020
• 4013585 FIX: SQL Server Analysis Service proactive caching processes a partition but doesn't run an SQL query, causing stale data Q4013585 KB4013585 December 18, 2020
• 4013111 FIX: DMV sys.dm_hadr_availability_group_states displays "NOT_HEALTHY" in synchronization_health_desc column on secondary replicas in SQL Server Q4013111 KB4013111 December 18, 2020
• 4011477 FIX: DMF sys.dm_db_incremental_stats_properties doesn't show all partitions if partitioning column is set to character or binary data type Q4011477 KB4011477 December 18, 2020
• 3212318 FIX: Can't set a database to partial containment if SQL Server change tracking was ever enabled on that database Q3212318 KB3212318 December 18, 2020
• 3093930 "Directory name is invalid" error when you try to install a SQL Server CAB (.exe) package by using Microsoft Edge in Windows 10 Q3093930 KB3093930 December 18, 2020
• 3080856 FIX: Information disclosure when you create a session cube by using dynamic role-based security in SQL Server 2012 or SQL Server 2014 Q3080856 KB3080856 December 18, 2020
• 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Q3025408 KB3025408 December 18, 2020
• 2009160 High CPU use occurs when you run queries in SQL Server Q2009160 KB2009160 December 17, 2020
• 956032 Error message when you run the Distribution Agent in SQL Server 2008 or in SQL Server 2008 R2: "The distribution agent failed to create temporary files" Q956032 KB956032 December 17, 2020
• 307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database" Q307864 KB307864 December 17, 2020
• 971268 "Evaluation period has expired" error message when working with SQL server Q971268 KB971268 December 1, 2020
• 969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q969052 KB969052 December 1, 2020
• 3005016 Orphaned XA transactions when you connect to SQL Server by using JDBC Driver for SQL Server Q3005016 KB3005016 November 8, 2020
• 955644 Description of the "access check cache bucket count" and "access check cache quota" options that are available in the sp_configure stored procedure Q955644 KB955644 November 8, 2020
• 914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server Q914288 KB914288 November 8, 2020
• 4533057 "Query optimizer generated too many subcubes" error and MDX query fails in SSAS multidimensional instance Q4533057 KB4533057 October 24, 2020
• 4470999 FIX: Problems occur in database backups from older versions of SQL Server Connector for Microsoft Azure Key Vault to version 1.0.5.0 Q4470999 KB4470999 October 24, 2020
• 4512016 FIX: Syscommittab cleanup causes a lock escalation that will block the syscommittab flush in SQL Server 2014, 2016 and 2017 Q4512016 KB4512016 October 23, 2020
• 4512011 FIX: Fix prefast warnings (62100) in Sql\Sqlrepl\xpreplclr.net\ReplCmdDataReader.cs to prevent SQL injection attacks Q4512011 KB4512011 October 23, 2020
• 4511868 FIX: Error 409 occurs when you back up databases by using BackuptoURL Q4511868 KB4511868 October 23, 2020
• 4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 October 23, 2020
• 4511750 FIX: SQL batch performance drops when you enable "Force Encryption" in SQL Server 2014 Q4511750 KB4511750 October 23, 2020
• 4511743 FIX: High CPU usage on Primary when SQL Service on Readable Secondary is turned off in Availability Group in SQL Server 2014 Q4511743 KB4511743 October 23, 2020
• 4511608 FIX: Full-text search fails to remove files from \FTDATA\FilterData subfolder in SQL Server 2014 Q4511608 KB4511608 October 23, 2020
• 4510934 FIX: Prolonged non-transactional usage of FileTable without instance restart may cause non-yielding scheduler error or server crash in SQL Server 2014, 2016 and 2017 Q4510934 KB4510934 October 23, 2020
• 4510122 FIX: An exception error occurs when you acquire a session lock during a logout audit event in SQL Server 2014 Q4510122 KB4510122 October 23, 2020
• 4503417 FIX: Assertion dump occurs when you select a view on a linked server in SQL Server 2017, 2016, or 2014 Q4503417 KB4503417 October 23, 2020
• 4502400 FIX: SQL Server 2014, 2016 and 2017 do not perform the requested pre-row assignments when you use MERGE statement that performs assignments of local variables for each row Q4502400 KB4502400 October 23, 2020
• 4500403 FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2014, 2016 and 2017 Q4500403 KB4500403 October 23, 2020
• 4499231 FIX: Log reader agent may fail after AG failover with TF 1448 enabled in SQL Server 2014, 2016 and 2017 Q4499231 KB4499231 October 23, 2020
• 4497701 FIX: Columnstore filter pushdown may return wrong results when there is an overflow in filter expressions in SQL Server 2014, 2016 and 2017 Q4497701 KB4497701 October 23, 2020
• 4497230 FIX: Fail to join the secondary replica if the database has a defunct filegroup in SQL Server 2014, 2016 and 2017 Q4497230 KB4497230 October 23, 2020
• 4492379 FIX: CDC source preview fails with "The given key was not present in the dictionary" in SQL Server 2014 Q4492379 KB4492379 October 23, 2020
• 4490140 FIX: Stack Dump occurs in the change tracking cleanup process in SQL Server 2014, 2016 and 2017 Q4490140 KB4490140 October 23, 2020
• 4489150 FIX: Filtered index may be corrupted when you rebuild index in parallel in SQL Server 2014, 2016 and 2017 Q4489150 KB4489150 October 23, 2020
• 4488809 FIX: Assertion occurs when a parallel query deletes from a Filestream table in SQL Server 2014, 2016 and 2017 Q4488809 KB4488809 October 23, 2020
• 4487957 FIX: Power BI Desktop queries may fail with error code 3238002710 in SSAS 2014 Q4487957 KB4487957 October 23, 2020
• 4483427 FIX: Access violation occurs and server stops unexpectedly when you use XEvent session with sqlos.wait_info event in SQL Server Q4483427 KB4483427 October 23, 2020
• 4480635 FIX: High CPU usage when there are many batch requests in SQL Server Q4480635 KB4480635 October 23, 2020
• 4471974 FIX: Stored procedure output parameters may return incorrectly when called through RPC with PREPARE option in SQL Server 2014 Q4471974 KB4471974 October 23, 2020
• 4467058 FIX: Query plans are different on clone database created by DBCC CLONEDATABASE and its original database in SQL Server 2014, 2016 and 2017 Q4467058 KB4467058 October 23, 2020
• 4338636 FIX: SQL jobs fail due to blocking in SSISDB in SQL Server 2014, 2016 and 2017 Q4338636 KB4338636 October 23, 2020
• 4073393 FIX: "The data area passed to a system call is too small" error when you start a Desktop Bridge application on a SQL Server Q4073393 KB4073393 October 23, 2020
• 4010990 FIX: SQL Server is stopped when you install patches on an instance of SQL Server that contains many databases Q4010990 KB4010990 October 23, 2020
• 4010710 FIX: Memory leak when you run a query that you don’t have sufficient permissions for in SQL Server 2014 or 2016 Q4010710 KB4010710 October 23, 2020
• 4010500 FIX: Sys.dm_tran_commit_table DMV and CHANGETABLE function return incorrect results if SQL Server shuts down unexpectedly Q4010500 KB4010500 October 23, 2020
• 4010162 FIX: A system assert occurs when a Transact-SQL stored procedure with a TVP argument is called from a SQLCLR procedure Q4010162 KB4010162 October 23, 2020
• 4010159 FIX: "Invoke-sqlcmd" cmdlet executes a query statement multiple times if an error occurs in SQL Server 2014 or 2016 Q4010159 KB4010159 October 23, 2020
• 4009823 FIX: AFTER DELETE triggers occur in the wrong order in the ON DELETE CASCADE action chain in SQL Server 2014 or 2016 Q4009823 KB4009823 October 23, 2020
• 913945 Microsoft does not certify that third-party products will work with Microsoft SQL Server Q913945 KB913945 October 23, 2020
• 4019091 Description of the security update for SQL Server 2014 Service Pack 1 GDR: August 8, 2017 Q4019091 KB4019091 October 20, 2020
• 3194720 MS16-136: Description of the security update for SQL Server 2014 Service Pack 1 GDR: November 8, 2016 Q3194720 KB3194720 October 20, 2020
• 917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server Q917825 KB917825 October 20, 2020
• 10179 Troubleshooting SQL Server AlwaysOn Issues Q10179 KB10179 October 3, 2020
• 321185 How to determine the version, edition, and update level of SQL Server and its components Q321185 KB321185 October 1, 2020
• 3189675 Join containment assumption in the New Cardinality Estimator degrades query performance in SQL Server 2014 and later Q3189675 KB3189675 September 29, 2020
• 3049257 Error 3989 or 3988 when a distributed query that joins multiple tables is hosted by remote instances of SQL Server Q3049257 KB3049257 September 29, 2020
• 294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster Q294209 KB294209 September 29, 2020
• 2295405 SQL Server service crashes when you run an Oracle linked server query Q2295405 KB2295405 August 18, 2020
• 2722715 Support for the leap second Q2722715 KB2722715 May 28, 2020
• 945934 How to register Microsoft Filter Pack IFilters with SQL Server Q945934 KB945934 April 30, 2020
• 2618570 "0x80770006" and "3201" errors after you install an instance of SQL Server 2008 R2 and later versions Q2618570 KB2618570 April 14, 2020
• 944837 Description of the Replay Markup Language (RML) Utilities for SQL Server Q944837 KB944837 April 10, 2020
• 2681562 Using SQL Server in Windows 8 and later versions of Windows operating system Q2681562 KB2681562 April 9, 2020
• 917047 Microsoft SQL Server I/O subsystem requirements for the tempdb database Q917047 KB917047 April 9, 2020
• 956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment Q956893 KB956893 March 31, 2020
• 2154845 Recommendations to reduce allocation contention in SQL Server tempdb database Q2154845 KB2154845 March 27, 2020
• 3120595 FIX: Column data may be deleted when you update another variable-length column in a table of a database upgraded from SQL Server 2005 Q3120595 KB3120595 February 20, 2020
• 2492477 SQL Agent job that executes a distributed query may fail with 65535, 782 or 7437 error messages Q2492477 KB2492477 February 4, 2020