SQL Server 2016 articles, fixes and updates - letter F

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

• 4540107 FIX: System or background task may fail when number of sessions reaches the maximum limit in SQL Server 2016, 2017 and 2019 Q4540107 KB4540107 August 27, 2024
• 3198751 FIX: Out-of-memory error when you run a query to access LOB columns through In-Memory OLTP in SQL Server 2016 Q3198751 KB3198751 August 27, 2024
• 4052136 FIX: SQL Server Audit Events don't write to the Security log Q4052136 KB4052136 July 4, 2024
• 4034376 FIX: Can't disable "change data capture" if any column is encrypted by "Always Encrypted" feature in SQL Server Q4034376 KB4034376 May 17, 2024
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 4575940 FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server Q4575940 KB4575940 April 26, 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
• 3194923 FIX: Error 976 occurs when you run DBCC CHECKDB on an unreadable secondary replica of SQL Server 2016 Availability Group Q3194923 KB3194923 November 11, 2022
• 4338960 FIX: "PAGE_FAULT_IN_NONPAGED_AREA" Stop error when enumerating contents in a SQL Server FileTable directory Q4338960 KB4338960 October 18, 2022
• 3157016 FIX: RDL report that's generated programmatically fails to run in SSRS Q3157016 KB3157016 October 18, 2022
• 4092554 FIX: Errors 627 or 12324 occur when cross database transactions are promoted to distributed transactions in SQL Server Availability Group Q4092554 KB4092554 September 22, 2022
• 4052133 FIX: Access violation when SQL Server 2016 tries to start Query Store Manager during startup Q4052133 KB4052133 August 2, 2022
• 4463320 FIX: Intermittent failures when you back up to Azure storage from SQL Server 2014, 2016 and 2017 Q4463320 KB4463320 June 21, 2022
• 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 June 21, 2022
• 4340730 FIX: Assertion error occurs when a query that uses a linked server is cancelled in SQL Server 2016 and 2017 Q4340730 KB4340730 June 21, 2022
• 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 June 21, 2022
• 4074862 FIX: Unexpected error when you create a subcube in SQL Server 2016 and 2017 Analysis Services (Multidimensional model) Q4074862 KB4074862 June 21, 2022
• 4057280 FIX: High CPU use when large index is used in a query on a memory-optimized table in SQL Server Q4057280 KB4057280 June 21, 2022
• 4042948 FIX: Data-driven subscription fails after you upgrade from SSRS 2008 to SSRS 2016 Q4042948 KB4042948 June 21, 2022
• 4561305 FIX: Concurrent inserts against tables with columnstore indexes may cause queries to stop responding in SQL Server Q4561305 KB4561305 June 2, 2022
• 4536005 FIX: Fix incorrect memory page accounting that causes out-of-memory errors in SQL Server Q4536005 KB4536005 June 2, 2022
• 4529876 FIX: Memory may not get released when you process partitions with data in SQL Server Q4529876 KB4529876 June 2, 2022
• 4521599 FIX: Non-yielding scheduler condition occurs if large number of row-column values are processed in row groups in SQL Server 2016 or 2017 Q4521599 KB4521599 June 2, 2022
• 4512567 FIX: "Non-yielding Scheduler" occurs when you run queries with batch-mode hash join and/or sort in SQL Server 2016 and 2017 Q4512567 KB4512567 June 2, 2022
• 4512151 FIX: Access Violation occurs when you use LOG function with a remote query in SQL Server 2016 and 2017 Q4512151 KB4512151 June 2, 2022
• 4512016 FIX: Syscommittab cleanup causes a lock escalation that will block the syscommittab flush in SQL Server 2014, 2016 and 2017 Q4512016 KB4512016 June 2, 2022
• 4506912 FIX: Concurrent inserts into a CCI can cause deadlock under memory pressure in SQL Server 2016 and 2017 Q4506912 KB4506912 June 2, 2022
• 4502428 FIX: Assertion error occurs when you run a query to access sys.dm_db_xtp_checkpoint_files in SQL Server 2016 and 2017 Q4502428 KB4502428 June 2, 2022
• 4497928 FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 and 2017 Q4497928 KB4497928 June 2, 2022
• 4497222 FIX: Database may crash when multiple threads update permissions on the same database in SQL Server 2016 and 2017 Q4497222 KB4497222 June 2, 2022
• 4494805 FIX: Adding new Publication may fail if distribution database is in AG and collation is set to BIN in SQL Server 2016 and 2017 Q4494805 KB4494805 June 2, 2022
• 4494225 FIX: Access violation occurs when you run a query against sys.availability_replicas in SQL Server 2016 and 2017 Q4494225 KB4494225 June 2, 2022
• 4491560 FIX: Access violation occurs when you query sys.dm_hadr_availability_replica_states in SQL Server 2016 and 2017 Q4491560 KB4491560 June 2, 2022
• 4490140 FIX: Stack Dump occurs in the change tracking cleanup process in SQL Server 2014, 2016 and 2017 Q4490140 KB4490140 June 2, 2022
• 4490138 FIX: Filtered NCI over a CCI may not be maintained when the table is updated in a way that none of the key or included columns of the NCI are changed in SQL Server 2016 and 2017 Q4490138 KB4490138 June 2, 2022
• 4486931 FIX: Upgrade to SQL Server 2016 SP2 CU3 or CU4 fails with an error when sysadmin account "sa" is renamed in SQL Server 2016 and 2017 Q4486931 KB4486931 June 2, 2022
• 4480652 FIX: SQL Writer Service can cause undetected deadlocks on system DMV when you do a VSS backup Q4480652 KB4480652 June 2, 2022
• 4469600 FIX: Peer-to-peer replication fails in SQL Server 2016 and 2017 if the host name is not uppercase Q4469600 KB4469600 June 2, 2022
• 4338773 FIX: Deadlock errors when you run an SSIS package in parallel in SQL Server Q4338773 KB4338773 June 2, 2022
• 3195888 FIX: High CPU usage causes performance issues in SQL Server 2016 and 2017 Q3195888 KB3195888 June 2, 2022
• 4563115 FIX: Upgrade script fails if you use an Always On high availability group as a secondary replica in SQL Server Q4563115 KB4563115 March 22, 2022
• 5007039 FIX: You encounter error messages 8114 or 22122 when performing change tracking cleanup Q5007039 KB5007039 October 27, 2021
• 5005689 FIX: SQL Server fails to start with error messages when an incorrect certificate is provisioned for SSL Q5005689 KB5005689 September 16, 2021
• 5005687 FIX: "SQLLocalDB.exe versions" stops listing the versions of LocalDB installed on the computer if SQL LocalDB 2016 SP1/SP2 is installed Q5005687 KB5005687 September 16, 2021
• 5005686 FIX: Setup fails when you install SQL Server on FCI with mount points Q5005686 KB5005686 September 16, 2021
• 5005453 FIX: SqlLocalDB.exe info doesn't display information about the specified LocalDB instance if SQL LocalDB 2016 SP2 is installed Q5005453 KB5005453 September 16, 2021
• 5004466 FIX: Update SQL Server 2017 and 2016 CEIP service to send usage and diagnostic data to a new endpoint Q5004466 KB5004466 September 16, 2021
• 5004059 FIX: Managed Backup fails to take full backup when backup preference is set to secondary on Read-Only secondary in SQL Server 2016 Q5004059 KB5004059 September 16, 2021
• 5003596 FIX: Log line is verbose when Always On Availability Group has many databases in SQL Server 2019 and 2016 Q5003596 KB5003596 September 16, 2021
• 4551720 FIX: Access violation exception occurs when promoting latches of frequently used database pages in SQL Server 2017 and 2016 Q4551720 KB4551720 September 16, 2021
• 4541303 FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server Q4541303 KB4541303 September 16, 2021
• 4531386 FIX: Assertion occurs when sys.sp_cdc_enable_table is used to enable CDC on column set table in SQL Server 2016 and 2017 Q4531386 KB4531386 September 15, 2021
• 4526524 FIX: SQL update package does not update Local DB files correctly when installed using SqlLocalDb.msi Q4526524 KB4526524 September 15, 2021
• 4515772 FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server Q4515772 KB4515772 September 15, 2021
• 4506023 FIX: Geocentric Datum of Australia 2020 is added to SQL Server 2017, 2016, and 2014 Q4506023 KB4506023 September 15, 2021
• 4493329 FIX: Error occurs when sp_addarticle is used to add article for transactional replication to memory-optimized table on subscriber in SQL Server 2017 and 2016 Q4493329 KB4493329 September 15, 2021
• 4046056 FIX: Assertion occurs when you access memory-optimized table through MARS in SQL Server 2017 or 2016 Q4046056 KB4046056 September 15, 2021
• 4039592 FIX: Cannot change the password for a SQL Server service account when additional LSA protection is enabled Q4039592 KB4039592 September 14, 2021
• 4589360 FIX: Error when you enable managed or automated backup in SQL Server 2016 and 2017 if "Allow Blob Public Access" is disabled on a storage account Q4589360 KB4589360 July 21, 2021
• 4023170 FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 Q4023170 KB4023170 June 10, 2021
• 5000651 FIX: Assert failure occurs when concurrent query modifies the same bitmap during clustered columnstore delete bitmap seek in SQL Server 2016 and 2017 Q5000651 KB5000651 May 11, 2021
• 4589350 FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server Q4589350 KB4589350 May 11, 2021
• 5000649 FIX: Wrong results due to undetected concatenation parameters from scalar expression Q5000649 KB5000649 April 7, 2021
• 5000650 FIX: Incorrect results occur when you run query on In-memory optimized table that has clustered columnstore index in SQL Server 2016 or 2019 Q5000650 KB5000650 April 6, 2021
• 4486936 FIX: "Login failed for user" error occurs when you run Maintenance plan with SQL login account in SQL Server Q4486936 KB4486936 April 6, 2021
• 5001114 FIX: Access Violation occurs during a concurrent columnstore index scan Q5001114 KB5001114 March 29, 2021
• 4585971 FIX: User session is in rollback state indefinitely after it is killed in SQL Server Q4585971 KB4585971 March 18, 2021
• 4568447 FIX: Automatic seeding failure occurs for a secondary replica in SQL Server Q4568447 KB4568447 February 27, 2021
• 4580397 FIX: Incorrect results when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server Q4580397 KB4580397 February 24, 2021
• 4575939 FIX: Log reader agent generates access violation exception for P2P or transactional replication with partitioning tables in SQL Server Q4575939 KB4575939 February 24, 2021
• 4569837 FIX: Intermittent connection error occurs when an expression is used for both connection string and password of a connection manager Q4569837 KB4569837 February 24, 2021
• 4547890 FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server Q4547890 KB4547890 February 24, 2021
• 4575689 FIX: Incorrect results can occur when you run linked server query with aggregates or joins on table with filtered index on a remote server in SQL Server Q4575689 KB4575689 February 15, 2021
• 5000652 FIX: Non-yielding condition occurs when you run a query in batch mode in SQL Server 2016 Q5000652 KB5000652 February 11, 2021
• 5852300 FIX: SQL Server 2014 or 2016 crashes on the execution of the DBCC CLONEDATABASE command Q5852300 KB5852300 January 26, 2021
• 4481148 FIX: Restore or Restore Verifyonly of a TDE-compressed backup fails with error 33111 and 3013 in SQL Server 2016 and 2017 Q4481148 KB4481148 January 26, 2021
• 4480653 FIX: Error occurs when you run a query that includes a Boolean field against PolyBase external tables in SQL Server 2016 and 2017 Q4480653 KB4480653 January 26, 2021
• 4476977 FIX: Error 5901 occurs on the same offset in SQL Server 2016 until server is restarted Q4476977 KB4476977 January 26, 2021
• 4476949 FIX: Database Mail cannot send emails after you install CU1, CU2 or CU3 for SQL Server 2016 Service Pack 2 Q4476949 KB4476949 January 26, 2021
• 4475794 FIX: Access violation exception occurs during Query Optimization of a query that accesses a table with Filtered Indexes or Statistics Q4475794 KB4475794 January 26, 2021
• 4475322 FIX: "Non-yielding" error occurs when there is a heavy use of prepared statements in SQL Server 2014, 2016 and 2017 Q4475322 KB4475322 January 26, 2021
• 4470916 FIX: Out of memory error occurs when Database Node Memory (KB) drops below 2 percent in SQL Server 2014 and 2016 Q4470916 KB4470916 January 26, 2021
• 4469554 FIX: Assertion error occurs during restore of compressed backups in SQL Server 2014, 2016 and 2017 Q4469554 KB4469554 January 26, 2021
• 4468103 FIX: Access violation occurs in Distribution Agent in SQL Server 2016 and 2017 Q4468103 KB4468103 January 26, 2021
• 4465745 FIX: Assertion error occurs when you run a MERGE statement with an OUTPUT clause in SQL Server 2016 and 2017 Q4465745 KB4465745 January 26, 2021
• 4461562 FIX: Transactions and log truncation may be blocked when you use Query Store in SQL Server 2016 and 2017 Q4461562 KB4461562 January 26, 2021
• 4460112 FIX: Access violation when you run a query that uses the XML data type in SQL Server 2014, 2016 and 2017 Q4460112 KB4460112 January 26, 2021
• 4459709 FIX: Poor performance occurs when you run a query against columnstore in an RCSI-enabled database in SQL Server 2016 and 2017 Q4459709 KB4459709 January 26, 2021
• 4459545 FIX: Upgrading SP1 instance fails when you use SxS instances of SQL Server 2016 SP1 and SP2 Q4459545 KB4459545 January 26, 2021
• 4457953 FIX: Access violations and unhandled exceptions when you set automatic seeding for secondary replica or Distributed Availability Group replica in SQL Server Q4457953 KB4457953 January 26, 2021
• 4346803 FIX: Error occurs when you run sp_send_dbmail stored procedure that contains comma in sender email address and name in SQL Server Q4346803 KB4346803 January 26, 2021
• 4341398 FIX: Event notifications for AUDIT_LOGIN and AUDIT_LOGIN_FAILED events will cause an unusual growth of TempDB in SQL Server 2016 and 2017 Q4341398 KB4341398 January 26, 2021
• 4340759 FIX: Slow performance of SQL Server 2016 when Query Store is enabled Q4340759 KB4340759 January 26, 2021
• 4340746 FIX: No records are returned when you run an MDX query after restarting SSAS 2016 and 2017 Q4340746 KB4340746 January 26, 2021
• 4339447 FIX: SSAS crashes when Process Full mode is executed after Process Clear in SQL Server 2016 Q4339447 KB4339447 January 26, 2021
• 4338890 FIX: "Non-yielding Scheduler" error and SQL Server appears unresponsive in SQL Server 2014, 2016 and 2017 Q4338890 KB4338890 January 26, 2021
• 4338761 FIX: SQL Server may generate EXCEPTION_ACCESS_VIOLATION dump file when you merge two partitions of system-versioned temporal tables in SQL Server 2016 or 2017 Q4338761 KB4338761 January 26, 2021
• 4338715 FIX: Many xml_deadlock_report events are reported for one single intra-query deadlock occurrence in SQL Server 2016 and 2017 Q4338715 KB4338715 January 26, 2021
• 4338040 FIX: Rectangle does not grow vertically together with internal Textbox in the report in SSRS 2016 when you set rc:Toolbar=False Q4338040 KB4338040 January 26, 2021
• 4092045 FIX: LSN truncation occurs in AlwaysOn AG when disabling the change data capture feature in SQL Server 2016 Q4092045 KB4092045 January 26, 2021
• 4091245 FIX: Access violation occurs when you query a table with an integer column in SQL Server 2017 and SQL Server 2016 Q4091245 KB4091245 January 26, 2021
• 4090486 FIX: Managed Backup fails when database is renamed with trailing white space in SQL Server 2016 and 2017 Q4090486 KB4090486 January 26, 2021
• 4090279 FIX: It takes a long time to roll back a batch that updates a large amount of data in SQL Server 2016 Q4090279 KB4090279 January 26, 2021
• 4090032 FIX: Memory gets exhausted when you run Power BI report that executes DAX query on SSAS 2014, 2016 and 2017 Multidimensional mode Q4090032 KB4090032 January 26, 2021
• 4089948 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2016 or 2017 Q4089948 KB4089948 January 26, 2021
• 4089819 FIX: "A time-out occurred while waiting for buffer latch -- type 4" error when you use Availability Groups in SQL Server 2016 or 2017 Q4089819 KB4089819 January 26, 2021
• 4089623 FIX: Out of memory occurs and query fails when you run MDX query with NON EMPTY option in SSAS Q4089623 KB4089623 January 26, 2021
• 4089324 FIX: Error 15665 when you call sp_set_session_context repeatedly with null key value in SQL Server 2016 and 2017 Q4089324 KB4089324 January 26, 2021
• 4089239 FIX: QRY_PROFILE_LIST_MUTEX is blocked when TF 7412 is enabled in SQL Server 2016 and 2017 Q4089239 KB4089239 January 26, 2021
• 4088193 FIX: Slow restore performance when restoring a compressed backup on a disk with 4K sector size in SQL Server Q4088193 KB4088193 January 26, 2021
• 4087358 FIX: Expression-based connection string is cleared out when you configure data sources for the report in SSRS 2016 Q4087358 KB4087358 January 26, 2021
• 4086136 FIX: SSAS stops responding when you run an MDX query in SQL Server 2016 and 2017 Analysis Services (Multidimensional model) Q4086136 KB4086136 January 26, 2021
• 4083949 FIX: SSAS may crash when you run a DAX query by using a non-admin Windows user in SQL Server 2016 and 2017 Q4083949 KB4083949 January 26, 2021
• 4078596 FIX: Random access violations occur when you run monitoring stored procedure in SQL Server 2016 and 2017 Q4078596 KB4078596 January 26, 2021
• 4077105 FIX: Out of memory error when the virtual address space of the SQL Server process is very low in SQL Server Q4077105 KB4077105 January 26, 2021
• 4058747 FIX: Error when upgrading SSIS catalog database in SQL Server 2016 and 2017 Standard Edition Q4058747 KB4058747 January 26, 2021
• 4058289 FIX: ALTER PROCEDURE WITH ENCRYPTION statement fails when you encrypt a non-published stored procedure in SQL Server 2016 and 2017 Q4058289 KB4058289 January 26, 2021
• 4058175 FIX: TDE-enabled backup and restore are slow if the encryption key is stored in an EKM provider in SQL Server Q4058175 KB4058175 January 26, 2021
• 4058174 FIX: Heavy tempdb contention occurs in SQL Server 2016 or 2017 Q4058174 KB4058174 January 26, 2021
• 4057759 FIX: Internal error when you drill down hierarchy members in SSAS 2016 and 2017 in multidimensional mode Q4057759 KB4057759 January 26, 2021
• 4057615 FIX: "Incorrect syntax near the keyword 'KEY'" error when you add an Oracle table with primary column named 'KEY' in SQL Server 2016 and 2017 Q4057615 KB4057615 January 26, 2021
• 4057212 FIX: Memory leak occurs when you back up a database that contains memory-optimized objects in SQL Server 2016 Q4057212 KB4057212 January 26, 2021
• 4057190 FIX: Error 14684 when you reconfigure Management Data Warehouse in a named instance of SQL Server 2016 and 2017 Q4057190 KB4057190 January 26, 2021
• 4057055 FIX: A deadlock occurs when you run a parallel query on a clustered columnstore index in SQL Server 2016 and 2017 Q4057055 KB4057055 January 26, 2021
• 4057054 FIX: CXPACKET and CXCONSUMER wait types show inconsistent results for some parallel query plans in SQL Server 2016 and 2017 Q4057054 KB4057054 January 26, 2021
• 4056831 FIX: Error 27231 occurs when SSIS package that contains localized language is deployed in SQL Server 2016 Q4056831 KB4056831 January 26, 2021
• 4056821 FIX: Log shipping fails when you use it together with Always On Availability Groups in SQL Server 2016 and 2017 Q4056821 KB4056821 January 26, 2021
• 4056117 FIX: Assertion occurs when you pass memory-optimized table variable into a stored procedure as table-valued parameter in SQL Server 2016 and 2017 Q4056117 KB4056117 January 26, 2021
• 4056008 FIX: "sp_special_columns" returns incorrect result in SQL Server 2014 and 2016 Q4056008 KB4056008 January 26, 2021
• 4055758 FIX: Inconsistent behavior for returning trailing blanks at the end of CHAR and BINARY data in SQL Server Q4055758 KB4055758 January 26, 2021
• 4055735 FIX: DBCC CHECKDB returns consistency errors if SOUNDEX function is used in PERSISTED computed columns in SQL Server Q4055735 KB4055735 January 26, 2021
• 4055727 FIX: Recovery of database takes a long time when it contains memory-optimized tables in SQL Server 2016 and 2017 Q4055727 KB4055727 January 26, 2021
• 4055674 FIX: Missing logs for Analysis Services Processing tasks in SQL Server 2016 and 2017 Integration Services Q4055674 KB4055674 January 26, 2021
• 4055556 FIX: Error when you rebuild a single partition of an index online in SQL Server 2014 and 2016 Q4055556 KB4055556 January 26, 2021
• 4055456 FIX: "Incompletely installed" error on Feature Selection page when you modify the current installation of SQL Server 2016 SP1 or SQL Server 2016 SP1 CU5 Q4055456 KB4055456 January 26, 2021
• 4055281 FIX: "Msg 3948" error when you run a query on secondary replica of secondary availability group in SQL Server 2016 and 2017 Q4055281 KB4055281 January 26, 2021
• 4054398 FIX: "Invalid comparison due to NO COLLATION" retail assert occurs in SQL Server 2014, 2016, and 2017 Q4054398 KB4054398 January 26, 2021
• 4053550 FIX: Processing XML message through Service Broker results in hung session in SQL Server 2016 and 2017 Q4053550 KB4053550 January 26, 2021
• 4052138 FIX: Parallel queries are slower when they are run with high DOP in SQL Server 2016 Q4052138 KB4052138 January 26, 2021
• 4052131 FIX: DMV sys.dm_os_windows_info returns wrong values for Windows 10 and Windows Server 2016 Q4052131 KB4052131 January 26, 2021
• 4052125 FIX: Audit Log for ROLLBACK TRANSACTION event is not available in SQL Server 2016 Q4052125 KB4052125 January 26, 2021
• 4052123 FIX: Sliding expiration for authentication cookie isn't working and fails to redirect to logon page in SSRS 2016 and 2017 Q4052123 KB4052123 January 26, 2021
• 4052119 FIX: New Distributed Transactions in an AG database fails after you restart DTC service in SQL Server 2016 Q4052119 KB4052119 January 26, 2021
• 4051360 FIX: Execution stats of scalar user-defined function is added to Showplan XML file in SQL Server 2016 SP2 Q4051360 KB4051360 January 26, 2021
• 4051356 FIX: In-memory database restore fails with errors in SQL Server 2016 and SQL Server 2017 Q4051356 KB4051356 January 26, 2021
• 4049027 FIX: "AdomdConnectionException" error when SSRS 2016 and 2017 data source uses msmdpump.dll Q4049027 KB4049027 January 26, 2021
• 4048967 FIX: Can't enable or disable change data capture for a database after you attach it in SQL Server 2014, 2016, or 2017 Q4048967 KB4048967 January 26, 2021
• 4048943 FIX: Access violation occurs on primary replica of AlwaysOn Availability Group in SQL Server Q4048943 KB4048943 January 26, 2021
• 4048942 FIX: Memory dumps generated for "Stalled IOCP Listener" and "non-yielding IOCP listener" after SQL Server restart Q4048942 KB4048942 January 26, 2021
• 4046914 FIX: Add CXPACKET wait type in showplan XML in SQL Server 2016 and 2017 Q4046914 KB4046914 January 26, 2021
• 4046909 FIX: LogPool cache MEMORYCLERK_SQLLOGPOOL consumes more memory when you do online transactions in SQL Server 2016 SP1 Express Edition Q4046909 KB4046909 January 26, 2021
• 4046745 FIX: UPDATE statement fails silently when you reference a nonexistent partition function in the WHERE clause in SQL Server 2014, 2016, or 2017 Q4046745 KB4046745 January 26, 2021
• 4044064 FIX: "Request timed out" error when you change security options for an MDS security group in SQL Server 2016 and 2017 Q4044064 KB4044064 January 26, 2021
• 4043947 FIX: Bookmarks functionality does not work completely when you open a report in MHTML format through Outlook in SSRS Q4043947 KB4043947 January 26, 2021
• 4042788 FIX: The tempdb system database is still encrypted after you turn off encryption on an instance of SQL Server Q4042788 KB4042788 January 26, 2021
• 4042415 FIX: Deadlock occurs on single-user mode database when many connections access it simultaneously in SQL Server 2014 and 2016 Q4042415 KB4042415 January 26, 2021
• 4042232 FIX: Access violation when you cancel a pending query if the missing indexes feature is enabled in SQL Server Q4042232 KB4042232 January 26, 2021
• 4041811 FIX: Automatic update of incremental statistics is delayed in SQL Server 2014, 2016 and 2017 Q4041811 KB4041811 January 26, 2021
• 4040510 FIX: A dump file is generated when you run a sp_execute_external_script statement in parallel mode in SQL Server 2016 Q4040510 KB4040510 January 26, 2021
• 4038881 FIX: Unexpected exception occurs when you process dimensions by using Process Update in SSAS 2016 or SSAS 2017 Q4038881 KB4038881 January 26, 2021
• 4038210 FIX: Change Data Capture stops working after a recent cumulative update for SQL Server is installed Q4038210 KB4038210 January 26, 2021
• 4037454 FIX: Policy-Based Management policy isn't working after you install CU2 for SQL Server 2016 SP1 Q4037454 KB4037454 January 26, 2021
• 4037435 FIX: Access violation occurs when you query the sys.availability_groups catalog view in SQL Server 2016 Q4037435 KB4037435 January 26, 2021
• 4037412 FIX: Error when SQL Server replication article contains either GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID Q4037412 KB4037412 January 26, 2021
• 4034056 FIX: Access violation occurs when you run a query in SQL Server 2016 Q4034056 KB4034056 January 26, 2021
• 4033178 FIX: Cast error when you open a local mode report in SharePoint Integrated mode in SSRS 2016 Q4033178 KB4033178 January 26, 2021
• 4032686 FIX: Search result isn't highlighted in SSRS 2016 report in SharePoint integrated mode Q4032686 KB4032686 January 26, 2021
• 4032200 FIX: Fail to compress the backup file when INIT and COMPRESSION option is used in a TDE enabled database in SQL Server 2016 Q4032200 KB4032200 January 26, 2021
• 4025261 FIX: The setting for deadlock priority doesn't work when you run the ALTER PARTITION FUNCTION statement in SQL Server 2016 Q4025261 KB4025261 January 26, 2021
• 4025208 FIX: Memory leak occurs when you use memory-optimized tables in Microsoft SQL Server 2016 Standard edition Q4025208 KB4025208 January 26, 2021
• 4024715 FIX: SharePoint sites that contain the Report Viewer Web Part fail to load after you upgrade from SharePoint 2013 to 2016 in SSRS 2016 Q4024715 KB4024715 January 26, 2021
• 4024548 FIX: It takes a long time to perform lots of write operations on SSAS databases in SQL Server 2016 Q4024548 KB4024548 January 26, 2021
• 4024449 FIX: Databases on secondary replica show "NOT SYNCHRONIZING" status after failover in SQL Server 2016 Q4024449 KB4024449 January 26, 2021
• 4024311 FIX: "Non-yielding Scheduler" condition occurs on spinlock contention in Microsoft SQL Server 2014 or 2016 Q4024311 KB4024311 January 26, 2021
• 4023419 FIX: Query with UNION ALL and a row goal may run slower in SQL Server 2014 or later versions when it's compared to SQL Server 2008 R2 Q4023419 KB4023419 January 26, 2021
• 4022935 FIX: Fails to resume a suspended availability database after a write error in SQL Server 2014 or 2016 Q4022935 KB4022935 January 26, 2021
• 4022873 FIX: "FILESTREAM feature is disabled" error when you use the FILESTREAM feature for SQL Server 2014 or 2016 in Windows 10 Creators Update Q4022873 KB4022873 January 26, 2021
• 4021243 FIX: Access violation when you create or configure an Always On availability group for an availability database in SQL Server 2012 and 2016 Q4021243 KB4021243 January 26, 2021
• 4019903 FIX: Query against sys.dm_db_partition_stats DMV runs slow if the database contains large numbers of columnstore partitions in SQL Server 2016 Q4019903 KB4019903 January 26, 2021
• 4019893 FIX: Restore fails when you do backup by using compression and checksum on a TDE enabled database in SQL Server 2016 Q4019893 KB4019893 January 26, 2021
• 4019803 FIX: KPIs appear in a random order when you add KPIs to the Favorites page in SSRS 2016 web portal Q4019803 KB4019803 January 26, 2021
• 4019718 FIX: Intra-query deadlock when you execute a parallel query that contains outer join operators in SQL Server 2016 Q4019718 KB4019718 January 26, 2021
• 4019511 FIX: SSAS 2016 fails to start if the MemoryHeapType and HeapTypeForObjects properties are set to "-1" Q4019511 KB4019511 January 26, 2021
• 4019445 FIX: Pie chart legend doesn't format percentage values properly in a SSRS 2016 mobile report Q4019445 KB4019445 January 26, 2021
• 4019285 FIX: Error when you execute DBCC CLONEDATABASE on an "Always Encrypted" enabled database in SQL Server 2014 or 2016 Q4019285 KB4019285 January 26, 2021
• 4019028 FIX: SQL Server 2016 consumes more memory when you reorganize a columnstore index Q4019028 KB4019028 January 26, 2021
• 4018955 FIX: Error when you process a calculated column on a database with compatibility level 1200 in SSAS 2016 tabular mode Q4018955 KB4018955 January 26, 2021
• 4018954 FIX: Domain entity drop-down displays an incorrect value when you connect to MDS by using MDS Add-in for Excel in SQL Server 2016 Q4018954 KB4018954 January 26, 2021
• 4018882 FIX: Mobile report does not display correct formatting when regional setting is set to Non-English in SSRS 2016 Q4018882 KB4018882 January 26, 2021
• 4018866 FIX: Parallel redo causes high memory usage in SQL Server 2016 when it's compared to SQL Server 2014 or earlier versions Q4018866 KB4018866 January 26, 2021
• 4017737 FIX: MDS entity sync fails if the Name or Code attribute contains non-default values in SQL Server 2016 Q4017737 KB4017737 January 26, 2021
• 4017445 FIX: A REDO thread is not available in the secondary replica after an availability database is dropped in SQL Server Q4017445 KB4017445 January 26, 2021
• 4017080 FIX: Transaction log backup failure on the secondary replica in SQL Server 2012 Always-On Availability Groups Q4017080 KB4017080 January 26, 2021
• 4016946 FIX: Deadlock when you use sys.column_store_row_groups and sys.dm_db_column_store_row_group_physical_stats DMV with large DDL operations in SQL Server 2016 Q4016946 KB4016946 January 26, 2021
• 4016945 FIX: "The custom resolver for this article requires OLEAUT32.DLL with a minimum version of 2.40.4276" error with merge publication in SQL Server Q4016945 KB4016945 January 26, 2021
• 4016902 FIX: Access violation when you use SELECT TOP query to retrieve data from clustered columnstore index in SQL Server 2016 Q4016902 KB4016902 January 26, 2021
• 4016361 FIX: Service Broker endpoint connections aren't closed after an availability group failover in SQL Server Q4016361 KB4016361 January 26, 2021
• 4015093 FIX: "rsUnknownReportParameter" error when you click a report from search results in SSRS 2016 Q4015093 KB4015093 January 26, 2021
• 4014862 FIX: Intermittent failure with System.NullReferenceException when you use custom authentication in SSRS 2014 or 2016 Q4014862 KB4014862 January 26, 2021
• 4014756 FIX: SQL Server Profiler fails to obfuscate sp_setapprole when it's executed from a remote procedure call in SQL Server Q4014756 KB4014756 January 26, 2021
• 4014738 FIX: Error occurs when you drop a subscription by using a non-sysadmin account in SQL Server Q4014738 KB4014738 January 26, 2021
• 4014734 FIX: SQL Server Launchpad service fails to start if the installed version of R Services (In-Database) is different from the Database Engine in SQL Server 2016 Q4014734 KB4014734 January 26, 2021
• 4013936 FIX: Hadoop File System Task fails after 10 minutes when you open and run a saved SSIS 2016 package Q4013936 KB4013936 January 26, 2021
• 4013851 FIX: Error when you add a NOT NULL column with default values to a non-empty clustered columnstore index in SQL Server 2016 Standard and Express edition Q4013851 KB4013851 January 26, 2021
• 4013248 FIX: User authentication failure in SSRS 2016 due to Report Server Web Service URL truncation under Custom Security Extensions deployment Q4013248 KB4013248 January 26, 2021
• 4013247 FIX: SSRS subscriptions fail to run for a report that connects to a SharePoint External list Q4013247 KB4013247 January 26, 2021
• 4013208 FIX: "Partition cannot contain column segments of different data versions" error when you process data on a partition in SSAS Tabular model Q4013208 KB4013208 January 26, 2021
• 4013128 FIX: Decreased performance and long waits for CLR_AUTO_EVENT and CMEMTHREAD when SQLCLR UDT is used as a stored procedure parameter for a SQL RPC call Q4013128 KB4013128 January 26, 2021
• 4010984 FIX: Assertion error when dm_exec_query_statistics_xml is used in a query plan that contains certain operators in SQL Server 2016 Q4010984 KB4010984 January 26, 2021
• 4010344 FIX: The sp_msx_enlist stored procedure fails to enlist a target server into a master server in SQL Server 2014 or 2016 if the server name is too long Q4010344 KB4010344 January 26, 2021
• 4009839 FIX: An MDX query returns incorrect results in SSAS 2014 or 2016 Tabular mode Q4009839 KB4009839 January 26, 2021
• 4009794 FIX: Internal Error "FAC_HK_INTERNAL" when you insert or update large number of rows of data into or in a memory-optimized table in SQL Server 2016 Q4009794 KB4009794 January 26, 2021
• 3216543 FIX: Workloads that utilize many frequent, short transactions in SQL Server 2016 and 2017 may consume more CPU than in SQL Server 2014 Q3216543 KB3216543 January 26, 2021
• 3213709 FIX: The SAMEPERIODLASTYEAR function does not work in DAX queries in SQL Server 2016 Analysis Services Q3213709 KB3213709 January 26, 2021
• 3213703 FIX: An Always On secondary replica goes into a disconnecting state Q3213703 KB3213703 January 26, 2021
• 3213683 FIX: Unable to rebuild the partition online for a table that contains a computed partitioning column in SQL Server 2014 or 2016 Q3213683 KB3213683 January 26, 2021
• 3213524 FIX: Text box is missing when the toggle action is enabled in SSRS 2016 Q3213524 KB3213524 January 26, 2021
• 3213291 FIX: Kernel crash when you create a database after you drop a database that contains FILESTEAM data in SQL Server 2016 Q3213291 KB3213291 January 26, 2021
• 3213288 FIX: DMV sys.dm_hadr_availability_replica_states returns an incorrect synchronization health state for a distributed availability group Q3213288 KB3213288 January 26, 2021
• 3213283 FIX: Error 3628 when you create or rebuild a columnstore index in SQL Server 2016 Q3213283 KB3213283 January 26, 2021
• 3213263 FIX: Error when creating a stored procedure that uses a synonym together with an index hint in SQL Server 2016 Q3213263 KB3213263 January 26, 2021
• 3213240 FIX: Changing the data type and then updating the table with more than 4,000 records causes database corruption Q3213240 KB3213240 January 26, 2021
• 3212916 FIX: SSAS may crash on query execution if a predefined role is specified in the connection string Q3212916 KB3212916 January 26, 2021
• 3212789 FIX: SQL Server crashes when you execute a spatial data query that has been compiled in SQL Server 2016 Q3212789 KB3212789 January 26, 2021
• 3212723 FIX: A query that contains a hint against a view that references at least one temporal table in a different database generates a dump file in SQL Server 2016 Q3212723 KB3212723 January 26, 2021
• 3212523 FIX: A memory leak occurs when SQL Server procedure cache consumes too much memory Q3212523 KB3212523 January 26, 2021
• 3212482 FIX: An access violation occurs when you execute DBCC CHECKDB on a database in SQL Server 2016 Q3212482 KB3212482 January 26, 2021
• 3212227 FIX: You can't run a data cleanse against a view in SQL Server 2016 Data Quality Services Q3212227 KB3212227 January 26, 2021
• 3212214 FIX: Cannot execute the DBCC CLONEDATABASE command on an instance of SQL Server 2014 or 2016 after an in-place upgrade Q3212214 KB3212214 January 26, 2021
• 3211991 FIX: SQL Server 2016 Reporting Services mobile reports can't be rendered in your browser through Active Directory Application Proxy Q3211991 KB3211991 January 26, 2021
• 3211948 FIX: "Adjust height to fit zone" setting of the SSRS 2016 Report Viewer Web Part isn't respected on a SharePoint webpage Q3211948 KB3211948 January 26, 2021
• 3211646 FIX: Latch Contention may occur on execution of parallel queries on database that has Snapshot Isolation enabled in SQL Server 2016 Q3211646 KB3211646 January 26, 2021
• 3211605 FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode Q3211605 KB3211605 January 26, 2021
• 3211602 FIX: Cannot insert data into a table that uses a clustered columnstore index in SQL Server 2016 Q3211602 KB3211602 January 26, 2021
• 3211338 FIX: An assert error occurs when you insert data into a memory-optimized table that contains a clustered columnstore index in SQL Server 2016 Q3211338 KB3211338 January 26, 2021
• 3211304 FIX: Error 5262 when you execute DBCC CHECKDB on the primary replica in SQL Server 2012, 2014 or 2016 Q3211304 KB3211304 January 26, 2021
• 3210747 FIX: The “sys.dm_db_column_store_row_group_physical_stats” query runs slowly on SQL Server 2016 Q3210747 KB3210747 January 26, 2021
• 3210708 FIX: Cannot install SQL Server R Services during an offline installation of SQL Server 2016 updates Q3210708 KB3210708 January 26, 2021
• 3210699 FIX: Errors are logged if database mirroring is configured by Transact-SQL in SQL Server 2016 Q3210699 KB3210699 January 26, 2021
• 3210597 FIX: SQL Server crashes when you execute the OPENJSON function in a contained database in SQL Server 2016 Q3210597 KB3210597 January 26, 2021
• 3210395 FIX: A dump file is generated when you enable system-versioning on a table in SQL Server 2016 Q3210395 KB3210395 January 26, 2021
• 3210087 FIX: Errors when you try to save MDS business rules in SQL Server 2016 Q3210087 KB3210087 January 26, 2021
• 3209878 FIX: SQL Server runs out of memory when you query data from memory-optimized tables if Resource Governor is enabled Q3209878 KB3209878 January 26, 2021
• 3209520 FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly Q3209520 KB3209520 January 26, 2021
• 3209459 FIX: Error 21050 when you remove a table that is not part of a publication in SQL Server 2014 or 2016 Q3209459 KB3209459 January 26, 2021
• 3209442 FIX: "No Data Available" in the SQL Server Memory Usage page in the SQL Server MDM report Q3209442 KB3209442 January 26, 2021
• 3209426 FIX: Processing a partition in SSAS 2016 drops all data from other partitions that are in the "incomplete" state Q3209426 KB3209426 January 26, 2021
• 3208524 FIX: You cannot select any replica when you fail over from an availability group that's in the resolving state Q3208524 KB3208524 January 26, 2021
• 3208460 FIX: DMV sys.dm_os_spinlock_stats returns incorrect results after you install SQL Server 2016 CU5 Q3208460 KB3208460 January 26, 2021
• 3208326 FIX: Can't take ownership of an availability group after the owner is dropped in SQL Server 2014 or 2016 Q3208326 KB3208326 January 26, 2021
• 3208245 FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014 or 2016 Q3208245 KB3208245 January 26, 2021
• 3208243 FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016 Q3208243 KB3208243 January 26, 2021
• 3208179 FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server Analysis Services Q3208179 KB3208179 January 26, 2021
• 3208178 FIX: Access violation when invalid credentials or connection string is specified in SQL Server 2016 Analysis Services Q3208178 KB3208178 January 26, 2021
• 3207327 FIX: On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server Q3207327 KB3207327 January 26, 2021
• 3206584 FIX: Checkpoint files grow excessively when you insert data into memory-optimized tables in SQL Server 2016 Q3206584 KB3206584 January 26, 2021
• 3206401 FIX: Out of memory occurs when you use long Hekaton transactions in SQL Server 2016 Q3206401 KB3206401 January 26, 2021
• 3206299 FIX: Availability databases in incorrect initializing/synchronizing state after failover of SQL Server 2014 or 2016 Always On availability group Q3206299 KB3206299 January 26, 2021
• 3205994 FIX: Memory leak when you query sys.dm_sql_referenced_entities view in SQL Server 2014 or 2016 Q3205994 KB3205994 January 26, 2021
• 3205964 FIX: An assertion occurs when you bulk insert data into a table from multiple connections in SQL Server 2016 Q3205964 KB3205964 January 26, 2021
• 3205935 FIX: Error 2809 when you execute a stored procedure that takes a table-valued parameter from RPC calls in SQL Server 2014 or 2016 Q3205935 KB3205935 January 26, 2021
• 3205411 FIX: "Non-yielding Scheduler" condition when you parallel-load data into a columnstore index in SQL Server 2016 Q3205411 KB3205411 January 26, 2021
• 3204769 FIX: Intra-query deadlock when values are inserted into a partitioned clustered columnstore index in SQL Server 2014 or 2016 Q3204769 KB3204769 January 26, 2021
• 3204469 FIX: Distribution Agent fails for a SQL Server 2014 publisher and a SQL Server 2012 subscriber in Transactional Replication Q3204469 KB3204469 January 26, 2021
• 3204265 FIX: Image maps not rendered as expected in SSRS custom report item Q3204265 KB3204265 January 26, 2021
• 3201865 FIX: The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout in SQL Server Q3201865 KB3201865 January 26, 2021
• 3201554 FIX: Long compilation time for a query that contains many distinct operators in SQL Server 2016 Q3201554 KB3201554 January 26, 2021
• 3201416 FIX: Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes in SQL Server 2014 or 2016 Q3201416 KB3201416 January 26, 2021
• 3200975 FIX: Assertion occurs when you use parallel redo in a secondary replica of a SQL Server AlwaysOn Availability Group Q3200975 KB3200975 January 26, 2021
• 3198827 FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members Q3198827 KB3198827 January 26, 2021
• 3198826 FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server Analysis Services Q3198826 KB3198826 January 26, 2021
• 3198766 FIX: Error 19432 after you upgrade Availability replicas in an Always On Availability Group to CU1 for SQL Server 2016 Q3198766 KB3198766 January 26, 2021
• 3198760 FIX: Error 19432 and time-out errors with SQL Server 2016 AlwaysOn Availability Groups Q3198760 KB3198760 January 26, 2021
• 3198356 FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services Q3198356 KB3198356 January 26, 2021
• 3198285 FIX: Parallel insert operation into a temp table causes SQL Server 2016 to freeze Q3198285 KB3198285 January 26, 2021
• 3198261 FIX: MDS business rule doesn't work if the Code value contains a leading space in SQL Server MDS Add-in for Excel Q3198261 KB3198261 January 26, 2021
• 3197952 FIX: Performance regression in the expression service during numeric arithmetic operations in SQL Server 2016 Q3197952 KB3197952 January 26, 2021
• 3197893 FIX: Rolling upgrade for AlwaysOn replica fails after Cumulative Update 1 for SQL Server 2016 is installed Q3197893 KB3197893 January 26, 2021
• 3197883 FIX: Snapshot Agent fails when you publish UDF’s to SQL Server 2016 Distributor in Transactional Replication Q3197883 KB3197883 January 26, 2021
• 3197879 FIX: SQL Server 2016 Database Mail causes high CPU usage after many email messages are sent Q3197879 KB3197879 January 26, 2021
• 3197758 FIX: Time-out error when you process multiple partitions in parallel in SQL Server 2016 Analysis Services (Tabular model) Q3197758 KB3197758 January 26, 2021
• 3197631 FIX: TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server Q3197631 KB3197631 January 26, 2021
• 3197605 FIX: SQL Server 2016 hangs when you restore databases that contain memory-optimized tables Q3197605 KB3197605 January 26, 2021
• 3197589 FIX: Heap scan may cause high PAGEIOLATCH_SH waits in SQL Server 2016 Q3197589 KB3197589 January 26, 2021
• 3197403 FIX: SQL Server 2016 Reporting Services keeps cycling to unload application domains when Report Server is configured on a Network Load Balancing Cluster Q3197403 KB3197403 January 26, 2021
• 3196450 FIX: The plaintext password is exposed in the connection string in SQL Server 2016 Analysis Services Q3196450 KB3196450 January 26, 2021
• 3196102 FIX: Performance issues caused by continuous growth of memory in SQL Server 2016 Analysis Services Q3196102 KB3196102 January 26, 2021
• 3196100 FIX: Exception occurs during parallel processing of partitions if a column is re-encoded in SQL Server 2016 Q3196100 KB3196100 January 26, 2021
• 3196012 FIX: Incorrect full-text keys are recorded for the rows that aren't indexed correctly by a full-text index in SQL Server Q3196012 KB3196012 January 26, 2021
• 3195901 FIX: SQL Server 2016 crashes when a Tuple Mover task is ended unexpectedly Q3195901 KB3195901 January 26, 2021
• 3195825 FIX: Deadlock when you execute a query plan with a nested loop join in batch mode in SQL Server 2014 or 2016 Q3195825 KB3195825 January 26, 2021
• 3194365 FIX: Rebuilding a nonclustered index to add columns by using CREATE INDEX with DROP_EXISTING=ON and ONLINE=ON causes blocking Q3194365 KB3194365 January 26, 2021
• 3192692 FIX: Assert memory dump on a mirror server in SQL Server Q3192692 KB3192692 January 26, 2021
• 3191062 FIX: FileTable directory stops responding when you create multiple files concurrently in SQL Server 2014 or 2016 Q3191062 KB3191062 January 26, 2021
• 3189959 FIX: Deadlock causes deferred transaction on the secondary replica in an Always On environment Q3189959 KB3189959 January 26, 2021
• 3189855 FIX: Intermittent non-yielding conditions, performance problems and intermittent connectivity failures in SQL Server 2016 Q3189855 KB3189855 January 26, 2021
• 3189709 FIX: Installation of Cumulative Update 1 for SQL Server 2016 fails on a named instance Q3189709 KB3189709 January 26, 2021
• 3189687 FIX: "'Salt' attribute for Password is missing in the project manifest" error in SQL Server Q3189687 KB3189687 January 26, 2021
• 3189663 FIX: SQL Server error log incorrectly cites logical processors when soft-NUMA is enabled Q3189663 KB3189663 January 26, 2021
• 3189229 FIX: "Element not found" error occurs when you browse to the FileTable database directory in SQL Server Q3189229 KB3189229 January 26, 2021
• 3188978 FIX: "Cannot bulk load" error when you run a query that contains an UPDATE statement in SQL Server 2016 Q3188978 KB3188978 January 26, 2021
• 3188368 FIX: Access violation on secondary replica when there are too many parallel redo operations in SQL Server 2016 Q3188368 KB3188368 January 26, 2021
• 3188160 FIX: Can't add new explicit hierarchies after deleting existing explicit hierarchies from an entity in SQL Server 2016 Master Data Services Q3188160 KB3188160 January 26, 2021
• 3188158 FIX: Filter and Change Tracking settings are removed after you change a domain-based attribute in SQL Server 2016 Master Data Services Q3188158 KB3188158 January 26, 2021
• 3188157 Functional area permissions are lost after you upgrade to SQL Server 2016 Master Data Services Q3188157 KB3188157 January 26, 2021
• 3188154 FIX: Can't filter attributes when using SQL Server 2016 Master Data Services Add-in on a non-English version of Excel Q3188154 KB3188154 January 26, 2021
• 3188153 FIX: Long time required to purge many members from an entity in SQL Server 2016 Master Data Services Q3188153 KB3188153 January 26, 2021
• 3188151 FIX: Can't save a business rule when the condition and action refer to different parent entities in SQL Server 2016 Master Data Services Q3188151 KB3188151 January 26, 2021
• 3187549 FIX: Affinity mask does not work correctly for NUMA nodes in SQL Server 2016 Analysis Services Q3187549 KB3187549 January 26, 2021
• 3187493 FIX: DISCOVER_TABLE_STORAGE_COLUMN_SEGMENTS DMV returns an incorrect result of memory usage in SQL Server 2016 Q3187493 KB3187493 January 26, 2021
• 3186435 FIX: SQL Server 2016 Database Mail does not work on a computer that does not have the .NET Framework 3.5 installed or stops working after applying SQL Server update Q3186435 KB3186435 January 26, 2021
• 3186433 FIX: Cannot print a SQL Server Reporting Services 2016 report from an application by using Report Viewer Control Q3186433 KB3186433 January 26, 2021
• 3183686 FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS Q3183686 KB3183686 January 26, 2021
• 3183345 FIX: Publication contains column filters stops working after restored from SQL Server 2005 to SQL Server 2012,2014 or 2016 Q3183345 KB3183345 January 26, 2021
• 3182868 FIX: Queries that contain recursive CROSS APPLY operations run slowly in SQL Server 2016 Q3182868 KB3182868 January 26, 2021
• 3181444 FIX: Queries that run against secondary databases always get recompiled in SQL Server Q3181444 KB3181444 January 26, 2021
• 3180263 FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 or 2016 Analysis Services Q3180263 KB3180263 January 26, 2021
• 3180060 FIX: Queries that use CHANGETABLE use much more CPU in SQL Server 2014 SP1 or in SQL Server 2016 Q3180060 KB3180060 January 26, 2021
• 3178137 FIX: Potential loss of historical data when you alter an in-memory temporal table in SQL Server 2016 Q3178137 KB3178137 January 26, 2021
• 3177238 FIX: No automatic failover after database mirroring stops unexpectedly in SQL Server Q3177238 KB3177238 January 26, 2021
• 3176993 FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 or 2016 Q3176993 KB3176993 January 26, 2021
• 3176440 FIX: DML statements are unexpectedly replicated to the subscribers in SQL Server 2014 or 2016 Q3176440 KB3176440 January 26, 2021
• 3175478 FIX: It takes a long time to compile a query and add it to the Query Store in SQL Server 2016 Q3175478 KB3175478 January 26, 2021
• 3175203 FIX: ShortestLineTo() and STDistance() methods return incorrect result for the shortest distance in SQL Server 2016 Q3175203 KB3175203 January 26, 2021
• 3174963 FIX: Data loss when you alter column operation on a large memory-optimized table in SQL Server 2016 Q3174963 KB3174963 January 26, 2021
• 3174829 FIX: "A network-related or instance-specific error occurred" when you repair SQL Server 2016 Q3174829 KB3174829 January 26, 2021
• 3174684 FIX: SQL Server 2016 uses all available memory and crashes when it runs a query that contains HASHBYTES functions Q3174684 KB3174684 January 26, 2021
• 3174436 FIX: Failed execution of ALTER AUDIT statement causes SQL Server to crash in SQL Server 2016 Q3174436 KB3174436 January 26, 2021
• 3174433 FIX: Error 10635 when you rebuild indexes online for tables that contain large object (LOB) columns in SQL Server 2016 Q3174433 KB3174433 January 26, 2021
• 3174395 FIX: sys.dm_external_script_execution_stats returns an incorrect counter_value in SQL Server 2016 Q3174395 KB3174395 January 26, 2021
• 3174088 FIX: Error 5283 when you run DBCC CHECKDB on a database that contains non-clustered columnstore index in SQL Server 2016 Q3174088 KB3174088 January 26, 2021
• 3173989 FIX: Availability databases are not fully started after you restart the server instance of SQL Server 2016 Q3173989 KB3173989 January 26, 2021
• 3173976 FIX: Fatal Error when you run a query against the sys.sysindexes view in SQL Server 2016 Q3173976 KB3173976 January 26, 2021
• 3173975 FIX: Checkpoint files are missing from sys.dm_db_xtp_checkpoint_files on SQL Server 2016 Q3173975 KB3173975 January 26, 2021
• 3173957 FIX: Cannot install a non-English version of SQL Server 2016 on a Windows Server that is installed in Server Core mode Q3173957 KB3173957 January 26, 2021
• 3173781 FIX: Unexpected exception when you make cross-appdomain TOM call in SQL Server 2016 Q3173781 KB3173781 January 26, 2021
• 3173779 FIX: Can’t create a database with a used database name by using the Create or CreateOrReplace command in SQL Server 2016 Q3173779 KB3173779 January 26, 2021
• 3173766 FIX: DBCC CHECKDB or CHECKTABLE returns false positives for data corruption and assertion failures in SQL Server 2014 or 2016 Q3173766 KB3173766 January 26, 2021
• 3173471 FIX: "Could not redo log record" error, and replica is suspended in SQL Server 2016, 2014, or 2012 Q3173471 KB3173471 January 26, 2021
• 3173087 FIX: PolyBase feature doesn't install when you add a node to a SQL Server 2016 failover cluster Q3173087 KB3173087 January 26, 2021
• 3173043 FIX: Wrong "schema_name" and "class_type" values for the CREATE SECURITY POLICY statement in SQL Server 2016 Q3173043 KB3173043 January 26, 2021
• 3172998 FIX: A severe error when you use the sys.dm_db_uncontained_entities DMV in SQL Server 2014 or 2016 Q3172998 KB3172998 January 26, 2021
• 3172981 FIX: Home page of SSRS web portal becomes empty after you enable My Reports feature in SQL Server 2016 Q3172981 KB3172981 January 26, 2021
• 3172974 FIX: Incorrect number of rows in sys.partitions for a columnstore index in SQL Server 2016 Q3172974 KB3172974 January 26, 2021
• 3172973 FIX: Assertion failure when you run UNION or UNION ALL clauses on a Row-Level Security enabled table in SQL Server 2016 Q3172973 KB3172973 January 26, 2021
• 3172959 FIX: Error 8061 when you use BULK INSERT on a table in SQL Server 2016 Q3172959 KB3172959 January 26, 2021
• 3172787 FIX: Can't force Row Mode sort by using session or query level trace flag 9347 in SQL Server 2016 Q3172787 KB3172787 January 26, 2021
• 3172671 FIX: BULK INSERT or OPENROWSET import wrong data if UTF-8 encoded file does not have a BOM in SQL Server 2016 Q3172671 KB3172671 January 26, 2021
• 3171932 FIX: Error message isn't localized completely when you use Tabular Model Scripting Language (TMSL) in SQL Server 2016 Q3171932 KB3171932 January 26, 2021
• 3171884 FIX: Unexpected exception when you add more maintenance plan tasks for an instance of SQL Server 2012 in SSMS 2016 Q3171884 KB3171884 January 26, 2021
• 3171882 FIX: SSMS can't save maintenance plans when you connect to an instance of SQL Server 2008 R2 or earlier versions Q3171882 KB3171882 January 26, 2021
• 3171863 FIX: Secondary replica in "not healthy" state after you upgrade the primary database in SQL Server 2016 Q3171863 KB3171863 January 26, 2021
• 3171544 FIX: Error 8624 occurs when you run a query against a nonclustered columnstore index in SQL Server 2016 Q3171544 KB3171544 January 26, 2021
• 3171505 FIX: "The service is not available" error when you use SSRS 2016 Portal after you disconnect from the domain Q3171505 KB3171505 January 26, 2021
• 3171480 FIX: Can't retrieve favorite KPIs or mobile reports in Power BI Mobile app or GetCatalogItem API in SQL Server 2016 Q3171480 KB3171480 January 26, 2021
• 3171475 FIX: Can't rename a catalog item with the same name in different case in SSRS 2016 Q3171475 KB3171475 January 26, 2021
• 3171001 FIX: Slow database recovery in SQL Server 2016 due to large log when you use In-Memory OLTP on a high-end computer Q3171001 KB3171001 January 26, 2021
• 3170999 FIX: Heavy concurrent OLTP activity runs slowly when delayed durability is enabled in SQL Server 2016 Q3170999 KB3170999 January 26, 2021
• 3170214 FIX: Can't generate an SSIS package when you use SQL Server Import and Export Wizard in SQL Server 2016 Q3170214 KB3170214 January 26, 2021
• 3170145 FIX: SSIS package doesn't run when you call it from executable files outside the DTS\Binn folder in SQL Server 2016 Q3170145 KB3170145 January 26, 2021
• 3170116 FIX: Memory grant that's required to run optimized nested loop join isn't reflected in Showplan XML in SQL Server Q3170116 KB3170116 January 26, 2021
• 3170084 FIX: Can't insert the NULL value into "ArgumentScript" column when you apply a business rule in SQL Server 2016 MDS Q3170084 KB3170084 January 26, 2021
• 3170083 FIX: Exception occurs when you associate an availability database with MDS web application in SQL Server 2016 Q3170083 KB3170083 January 26, 2021
• 3170082 FIX: Permission issue or failure occurs when you upgrade to SQL Server 2016 Master Data Services Q3170082 KB3170082 January 26, 2021
• 3170079 FIX: Permission issues when you use SQL Server 2016 Master Data Services Q3170079 KB3170079 January 26, 2021
• 3170076 FIX: Data loss when you run the udpConvertCollectionAndConsolidatedMembersToLeaf stored procedure in SQL Server 2016 MDS Q3170076 KB3170076 January 26, 2021
• 3170074 FIX: Unexpected exception occurs when deploying a package using SQL Server 2016 MDSModelDeploy tool Q3170074 KB3170074 January 26, 2021
• 3170051 FIX: SQL Server failover cluster diagnostic log doesn't accurately reflect the failure_condition_level setting Q3170051 KB3170051 January 26, 2021
• 3169923 Fixes some issues about assistive technology tools in SSRS 2016 Q3169923 KB3169923 January 26, 2021
• 3168793 FIX: Cannot create or delete a table or index when another DDL transaction is running on the same database in SQL Server 2016 Q3168793 KB3168793 January 26, 2021
• 3168710 FIX: CONTEXT_INFO returns incorrect values when context_info ends with two trailing zeros in SQL Server 2014 or 2016 Q3168710 KB3168710 January 26, 2021
• 3168708 FIX: SQL Server Managed Backup to Windows Azure tries to back up database snapshots in SQL Server Q3168708 KB3168708 January 26, 2021
• 3168707 FIX: Retention policy does not work when you use SQL Server Managed Backup to Windows Azure in SQL Server 2014 or 2016 Q3168707 KB3168707 January 26, 2021
• 3168571 FIX: The SEEDING_MODE setting is ignored when you add an AlwaysOn AG replica to an existing AG in SQL Server 2016 Q3168571 KB3168571 January 26, 2021
• 3168242 FIX: Processor group affinity issues in SQL Server 2016 Analysis Services (Tabular mode) Q3168242 KB3168242 January 26, 2021
• 3168200 FIX: Only one Boolean parameter can select default value when you have multiple Boolean parameters in SSRS 2016 Q3168200 KB3168200 January 26, 2021
• 3167434 FIX: SSRS logs fill up the hard disk and agent jobs are not recreated after database migration in SQL Server 2016 Q3167434 KB3167434 January 26, 2021
• 3167175 FIX: The "Select All" check box doesn't work in the subscriptions page in SSRS 2016 Q3167175 KB3167175 January 26, 2021
• 3167174 FIX: Subscriptions that are filtered out are still affected by the actions in SSRS 2016 Q3167174 KB3167174 January 26, 2021
• 3167159 FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan Q3167159 KB3167159 January 26, 2021
• 3166120 FIX: "Could not find stored procedure 'sys.sp_cdc_parse_captured_column_list'" error in SQL Server 2016 Q3166120 KB3166120 January 26, 2021
• 3165545 FIX: Unable to execute FORMAT function if it is wrapped inside CLR in SQL Server Q3165545 KB3165545 January 26, 2021
• 3162589 FIX: Decreased SQL Server performance when there is elevated privileged mode CPU usage and a high volume of page latch waits Q3162589 KB3162589 January 26, 2021
• 3162396 FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Q3162396 KB3162396 January 26, 2021
• 3161119 FIX: Change tracking cleanup task fails if another database is offline in SQL Server 2014 or 2016 Q3161119 KB3161119 January 26, 2021
• 3160303 FIX: Incorrect results when you use a LIKE operator and an "ss" wildcard in SQL Server 2014 or 2016 Q3160303 KB3160303 January 26, 2021
• 3159748 FIX: Cannot connect to a named instance after failover on a mirror server in SQL Server 2014 or 2016 Q3159748 KB3159748 January 26, 2021
• 3158710 FIX: The ALTER SERVER CONFIGURATION with SET SOFTNUMA command does not work in SQL Server 2016 Q3158710 KB3158710 January 26, 2021
• 3158388 FIX: SQL Server 2016 MDS database is not visible in SQL Server 2012 MDS Configuration Manager Q3158388 KB3158388 January 26, 2021
• 3157575 FIX: Copy Database Wizard fails when a table contains a sparse column set in SQL Server Q3157575 KB3157575 January 26, 2021
• 3155503 FIX: MERGE statement to sync tables is unsuccessful when change data capture is enabled in SQL Server 2012, 2014, or 2016 Q3155503 KB3155503 January 26, 2021
• 3155209 FIX: Can't delete a row from a filtered table part of a merge publication in SQL Server 2012, 2014, or 2016 Q3155209 KB3155209 January 26, 2021
• 3154226 FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server Q3154226 KB3154226 January 26, 2021
• 3152965 FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server Q3152965 KB3152965 January 26, 2021
• 3152596 FIX: Unicode characters are displayed as square blocks after you paste them from an SSRS report Q3152596 KB3152596 January 26, 2021
• 3152378 FIX: FileTables in an AlwaysOn availability group become unavailable after failover in an instance of SQL Server Q3152378 KB3152378 January 26, 2021
• 3152377 FIX: Error 5120 when you create or use a FILESTREAM-enabled database on a dynamic disk in an instance of SQL Server 2014 or 2016 Q3152377 KB3152377 January 26, 2021
• 3152135 FIX: An access violation occurs when you run a spatial query that contains OPENQUERY methods through a linked server in SQL Server 2014 or 2016 Q3152135 KB3152135 January 26, 2021
• 3152042 FIX: PageRequestManagerServerErrorException error when you use an invalid date parameter in SSRS Q3152042 KB3152042 January 26, 2021
• 3150896 FIX: A "Non-yielding Scheduler" condition occurs when you perform a BULK INSERT and the data file exists in a FileTable in SQL Server Q3150896 KB3150896 January 26, 2021
• 3150152 FIX: Estimated number of rows is calculated incorrectly for a predicate involving a unique GUID column in SQL Server 2014 or 2016 Q3150152 KB3150152 January 26, 2021
• 3147012 FIX: Large disk checkpoint usage occurs for an In-Memory optimized filegroup during heavy non-In-Memory workloads Q3147012 KB3147012 January 26, 2021
• 3146404 FIX: Canceling a backup task crashes SQL Server Q3146404 KB3146404 January 26, 2021
• 3138321 FIX: "Non-yielding Scheduler" condition when you run a query that contains a UNION operation in SQL Server 2014 or 2016 Q3138321 KB3138321 January 26, 2021
• 3136496 FIX: Access violation occurs when a query references an SQLCLR function through a synonym in SQL Server 2014 and 2016 Q3136496 KB3136496 January 26, 2021
• 3136205 FIX: "Failed to create a new table" error when you export the cleansing results of a Data Quality Services domain in SQL Server Q3136205 KB3136205 January 26, 2021
• 3132062 FIX: SMK initialization fails on one node of a SQL Server 2012, 2014, or 2016 failover cluster Q3132062 KB3132062 January 26, 2021
• 3132058 FIX: Error occurs when you try to drop or delete filegroups or partition schemes and functions in SQL Server Q3132058 KB3132058 January 26, 2021
• 3131443 FIX: "Cannot resolve the collation conflict" error when you apply a snapshot to the subscriber database in SQL Server Q3131443 KB3131443 January 26, 2021
• 3115741 FIX:"The process cannot access the file" error when an XML task fails in SQL Server Q3115741 KB3115741 January 26, 2021
• 3106976 FIX: An access violation occurs when you use the TDE and BPE features in SQL Server 2014 or 2016 Q3106976 KB3106976 January 26, 2021
• 3070382 FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name Q3070382 KB3070382 January 26, 2021
• 3067968 FIX: Memory is paged out when columnstore index query consumes lots of memory in SQL Server 2014 or 2016 Q3067968 KB3067968 January 26, 2021
• 3065060 FIX: "Unable to create restore plan due to break in the LSN chain" error when you restore differential backup in SSMS Q3065060 KB3065060 January 26, 2021
• 3030352 FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server database Q3030352 KB3030352 January 26, 2021
• 3028216 FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS Q3028216 KB3028216 January 26, 2021
• 3026083 FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server Q3026083 KB3026083 January 26, 2021
• 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Q3025408 KB3025408 January 26, 2021
• 3010148 FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS Q3010148 KB3010148 January 26, 2021
• 2963836 FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS Q2963836 KB2963836 January 26, 2021
• 2932559 FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS Q2932559 KB2932559 January 26, 2021
• 4587239 FIX: Assertion error occurs when the Availability Group is failed over manually to another replica in SQL Server 2016 Q4587239 KB4587239 January 20, 2021
• 4578496 FIX: Slow performance occurs as CMEMTHREAD waits occur due to temporary table cachestore memory object contention in SQL Server 2016 and 2017 Q4578496 KB4578496 January 20, 2021
• 4578008 FIX: Managed backup is not backing up the database when SQL Agent system jobs are changed to different name other than 'sa' in SQL Server 2016 and 2017 Q4578008 KB4578008 January 20, 2021
• 4576757 FIX: Access violation occurs when you query cloned database in SQL Server 2016 Q4576757 KB4576757 January 20, 2021
• 4568653 FIX: INSERT EXEC doesn't work when you insert row containing explicit identity value into table with IDENTITY column and IDENTITY_INSERT is OFF by default in SQL Server Q4568653 KB4568653 January 20, 2021
• 4563597 FIX: Assertion dump may occur when Implicit Transactions are enabled in SQL Server 2019, 2017, and 2016 Q4563597 KB4563597 January 20, 2021
• 4562173 FIX: Availability Group failover generates lot of dumps as DTC support is toggled between PER_DB and NONE multiple times Q4562173 KB4562173 January 20, 2021
• 4560183 FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server Q4560183 KB4560183 January 20, 2021
• 4556096 FIX: SSRS 2016 URLs are case-sensitive after applying Security Update GDRs KB4532097 or KB4535706 Q4556096 KB4556096 January 20, 2021
• 4543027 FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server Q4543027 KB4543027 January 20, 2021
• 4541770 FIX: Assertion failure occurs when persistent log buffer is used in SQL Server Q4541770 KB4541770 January 20, 2021
• 4541769 FIX: Error occurs when running sp_updatestats on the table that has a clustered columnstore index and memory optimized index Q4541769 KB4541769 January 20, 2021
• 4541762 FIX: Management Data Warehouse Server Activity Collection Set may fail in SQL Server Q4541762 KB4541762 January 20, 2021
• 4541724 FIX: Intermittent non-yielding scheduler occurs when memory-optimized database running under heavy I/O activities in SQL Server Q4541724 KB4541724 January 20, 2021
• 4541520 FIX: Assertion occurs when you process a malformed XML message sent as message in Service Broker queue in SQL Server Q4541520 KB4541520 January 20, 2021
• 4541435 FIX: Error occurs when you rename a column on temporal current table in SQL Server Q4541435 KB4541435 January 20, 2021
• 4541385 FIX: Database initialization may fail by using automatic seeding in SQL Server 2016 Q4541385 KB4541385 January 20, 2021
• 4541309 FIX: Missing log block may occur when you use Always On availability group in SQL Server Q4541309 KB4541309 January 20, 2021
• 4541300 FIX: Fix incorrect values in auto seeding XEvents in SQL Server Q4541300 KB4541300 January 20, 2021
• 4541288 FIX: Non-yielding scheduler dumps occur when running a batch mode query with multiple joins in SQL Server 2016 Q4541288 KB4541288 January 20, 2021
• 4541096 FIX: Access Violation occurs when you run query on computed columns in SQL Server Q4541096 KB4541096 January 20, 2021
• 4540903 FIX: Non-yielding scheduler dump occurs in InterlockedCompareExchangePointer and SOS_RWLock in SQL Server 2016, 2017 and 2019 Q4540903 KB4540903 January 20, 2021
• 4540901 FIX: SQL Server may terminate due to lock conflicts during error message processing in SQL Server 2016, 2017 and 2019 Q4540901 KB4540901 January 20, 2021
• 4540896 FIX: Access violation may occur when enumerating files in a FileTable in SQL Server Q4540896 KB4540896 January 20, 2021
• 4540731 FIX: Unexpected exception error occurs when you run DISCOVER_CSDL_METADATA in Power BI Desktop in SQL Server 2016 Q4540731 KB4540731 January 20, 2021
• 4540449 FIX: Error occurs in sp_xml_preparedocument where MSXMLSQL tries to access virtual address space beyond limit in SQL Server 2016, 2017 and 2019 Q4540449 KB4540449 January 20, 2021
• 4540385 FIX: DAX query causes server to have exceptions in TBB heap and crash in Windows heap in SQL Server 2016 and 2017 Q4540385 KB4540385 January 20, 2021
• 4540346 FIX: MERGE statement fails with assert “Attempt to access expired blob handle (1)” in SQL Server 2016, 2017 and 2019 Q4540346 KB4540346 January 20, 2021
• 4540342 FIX: Non-yielding scheduler condition occurs with CONNECTION_MANAGER spinlock in SQL Server Q4540342 KB4540342 January 20, 2021
• 4539947 FIX: Assertion occurs when you run DATABASE SCOPED command in SQL Server 2016 Q4539947 KB4539947 January 20, 2021
• 4539897 FIX: Access violation may occur when you run XML query against a table that has a primary XML index in SQL Server 2016 Q4539897 KB4539897 January 20, 2021
• 4539892 FIX: Error occurs when you run a stored procedure from database A which pulls data from database B in SQL Server 2016 Q4539892 KB4539892 January 20, 2021
• 4539880 FIX: Access violation occurs with wait_info XEvent on busy SQL Server Q4539880 KB4539880 January 20, 2021
• 4539815 FIX: Access violation occurs when change tracking auto cleanup tries to clean up side tables in SQL Server Q4539815 KB4539815 January 20, 2021
• 4538378 FIX: The "is_media_read_only" value remains unchanged for a SQL Server data file even though the media is no longer read-only Q4538378 KB4538378 January 20, 2021
• 4537350 FIX: Access Violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server Q4537350 KB4537350 January 20, 2021
• 4531027 FIX: Assertion error occurs when you run getHKTable function to get Hekaton database in SQL Server 2016 Q4531027 KB4531027 January 20, 2021
• 4531010 FIX: CREATE INDEX with new CE reads the partition table and results in huge row count higher than the total table row count in SQL Server Q4531010 KB4531010 January 20, 2021
• 4530720 FIX: "The File location cannot be opened" error occurs when you try to open a FileTable directory in SQL Server Q4530720 KB4530720 January 20, 2021
• 4530500 FIX: Assertion dump occurs when sp_cdc_disable_db is executed to disable CDC or when distributed transaction is committed after ROLLBACK SAVEPOINT in SQL Server Q4530500 KB4530500 January 20, 2021
• 4530475 FIX: IsError function fails to detect error in Excel XIRR function when MDX query is executed from SSIS Q4530475 KB4530475 January 20, 2021
• 4530443 FIX: Non-yielding scheduler issue occurs in SQL Server when you run an online build for an index that's not partition-aligned Q4530443 KB4530443 January 20, 2021
• 4530259 FIX: Scripts generated by SSMS collect different wait types after you install SQL Server Q4530259 KB4530259 January 20, 2021
• 4530251 FIX: Error 8601 occurs when you run a query with partition function in SQL Server Q4530251 KB4530251 January 20, 2021
• 4530212 FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server Q4530212 KB4530212 January 20, 2021
• 4529942 FIX: Restore fails when you try to restore compressed TDE backups prior to SQL Server 2016 SP2 CU4 on SQL Server 2016 SP2 CU8 Q4529942 KB4529942 January 20, 2021
• 4528250 FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server Q4528250 KB4528250 January 20, 2021
• 4528130 FIX: Access violation occurs when you restore the In-Memory Optimized database in SQL Server 2016 and 2017 Q4528130 KB4528130 January 20, 2021
• 4528067 FIX: Error 8959 may occur on IAM page when you query sys.dm_db_index_physical_stats against partitioned columnstore table after partition switch in SQL Server Q4528067 KB4528067 January 20, 2021
• 4528066 FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 and 2019 because of NCCI Q4528066 KB4528066 January 20, 2021
• 4528065 FIX: DBCC CHECKDB with EXTENDED_LOGICAL_CHECKS fails on a table in SQL Server 2016 Q4528065 KB4528065 January 20, 2021
• 4527716 FIX: You may encounter a non-yielding scheduler condition when you run query with parallel batch-mode sort operator in SQL Server Q4527716 KB4527716 January 20, 2021
• 4527510 FIX: User hierarchy is not hidden when you run DISCOVER_CSDL_METADATA in SQL Server Q4527510 KB4527510 January 20, 2021
• 4527355 FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server Q4527355 KB4527355 January 20, 2021
• 4527229 FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server Q4527229 KB4527229 January 20, 2021
• 4526315 FIX: Database cannot recover and reports error 5243 in SQL Server Q4526315 KB4526315 January 20, 2021
• 4525612 FIX: BorderStyle property of TextBox controls may not be rendered in EXCELOPENXML format in SQL Server 2016 Q4525612 KB4525612 January 20, 2021
• 4525483 FIX: Exception error 3628 may occur when you run stored procedure in SQL Server Q4525483 KB4525483 January 20, 2021
• 4524542 FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU Q4524542 KB4524542 January 20, 2021
• 4523102 FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS Q4523102 KB4523102 January 20, 2021
• 4522134 FIX: Subscriptions fail after you upgrade from SSRS 2012 to SSRS 2016 because of invalid character in mail header Q4522134 KB4522134 January 20, 2021
• 4522127 FIX: Poor query performance due to low cardinality estimation in SQL Server 2016 when you use default CE and column is covered by both single and multi-column statistics Q4522127 KB4522127 January 20, 2021
• 4522126 FIX: You may receive wrong results when you query sys.database_scoped_configurations in SQL Server 2016 Q4522126 KB4522126 January 20, 2021
• 4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019 Q4521960 KB4521960 January 20, 2021
• 4521701 FIX: Cardinality property for a table doesn't include rows in the delta store or deleted bitmap if the table has a clustered columnstore index Q4521701 KB4521701 January 20, 2021
• 4521659 FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016, 2017 and 2019 Q4521659 KB4521659 January 20, 2021
• 4520739 FIX: Access violation error occurs when you try to insert results of stored procedure into a table with dynamic data masking in SQL Server 2016 and 2017 Q4520739 KB4520739 January 20, 2021
• 4520266 FIX: When you change SEEDING_MODE to MANUAL using ALTER AVAILABILITY GROUP, SQL Server 2016 does not cancel the current seeding operations to the secondary replica Q4520266 KB4520266 January 20, 2021
• 4520124 FIX: Unable to mount SQL Server FILESTREAM share from Linux with SMB 3.x protocol Q4520124 KB4520124 January 20, 2021
• 4520109 FIX: Access violation occurs when you restore In-Memory OLTP database in SQL Server 2016 Q4520109 KB4520109 January 20, 2021
• 4519847 FIX: MDS Configuration Manager reports SP2 base version in SQL Server 2016 Q4519847 KB4519847 January 20, 2021
• 4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019 Q4519796 KB4519796 January 20, 2021
• 4519682 FIX: Azure Site Recovery and other VSS jobs may report failures on servers hosting SQL Server 2016 instances Q4519682 KB4519682 January 20, 2021
• 4519679 FIX: Different users get the same model list with different permissions in SQL Server 2016 and 2017 Q4519679 KB4519679 January 20, 2021
• 4519668 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016, 2017 and 2019 Q4519668 KB4519668 January 20, 2021
• 4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server Q4519366 KB4519366 January 20, 2021
• 4518364 FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016, 2017 and 2019 Q4518364 KB4518364 January 20, 2021
• 4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server Q4517771 KB4517771 January 20, 2021
• 4513238 FIX: Error 9003 occurs when you back up a database on a secondary replica in Microsoft SQL Server 2016 and 2017 Q4513238 KB4513238 January 20, 2021
• 4513236 FIX: Internal thread deadlock may occur on primary or secondary replica of availability group in SQL Server 2016 SP2 and 2017 Q4513236 KB4513236 January 20, 2021
• 4513099 FIX: Azure storage I/O subsystem may not reset transfer details for a failed I/O resulting in backup errors Q4513099 KB4513099 January 20, 2021
• 4513097 FIX: Restore or RESTORE VERIFYONLY of a TDE-compressed backup fails in SQL Server 2016 and 2017 Q4513097 KB4513097 January 20, 2021
• 4513096 FIX: Repair fails for Machine Learning components on server with no Internet access Q4513096 KB4513096 January 20, 2021
• 4512956 FIX: Querying sys.tables returns temporary tables created by concurrent users starting from SQL Server 2012 Q4512956 KB4512956 January 20, 2021
• 4512821 FIX: Multidimensional mode randomly crashes and an access violation occurs in SQL Server 2016 Q4512821 KB4512821 January 20, 2021
• 4512558 FIX: Assertion error occurs when SQL Server 2016 and 2017 use hash join, hash aggregate, sort or window function in batch-mode plan Q4512558 KB4512558 January 20, 2021
• 4512130 FIX: Data masking may not be applied when you use PIVOT or UNPIVOT function on masked column in SQL Server 2016 and 2017 Q4512130 KB4512130 January 20, 2021
• 4511868 FIX: Error 409 occurs when you back up databases by using BackuptoURL Q4511868 KB4511868 January 20, 2021
• 4511834 FIX: Memory dumps generate when access violation occurs in SQL Server 2016 Q4511834 KB4511834 January 20, 2021
• 4511816 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016 Q4511816 KB4511816 January 20, 2021
• 4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 January 20, 2021
• 4511751 FIX: Access violation error occurs when SQL Server 2016 and 2017 uses hash join, hash aggregate, sort or window function in batch-mode plan in the deadlock monitor Q4511751 KB4511751 January 20, 2021
• 4511715 FIX: Filled transaction log causes outages when you run Query Store in SQL Server 2016 and 2017 Q4511715 KB4511715 January 20, 2021
• 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 January 20, 2021
• 4508621 FIX: Data processing is much slower in SSAS 2016 SP2 and 2017 than in SSAS 2016 SP1 Q4508621 KB4508621 January 20, 2021
• 4508472 FIX: Intermittent "row not found" error at Azure SQL DB Subscriber caused by duplication of BEGIN TRAN statements Q4508472 KB4508472 January 20, 2021
• 4503417 FIX: Assertion dump occurs when you select a view on a linked server in SQL Server 2017, 2016, or 2014 Q4503417 KB4503417 January 20, 2021
• 4503385 FIX: DAX query requires more than 200 times of memory than the size of the database in SQL Server 2016 and 2017 multidimensional model database Q4503385 KB4503385 January 20, 2021
• 4502658 FIX: "No valid credentials provided" occurs after you restart PolyBase in SQL Server 2016 and 2017 Q4502658 KB4502658 January 20, 2021
• 4502427 FIX: Access violation occurs when you run sys.fn_dump_dblog function in SQL Server 2016 and 2017 Q4502427 KB4502427 January 20, 2021
• 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 January 20, 2021
• 4501797 FIX: Data movement to DAG Forwarder does not resume automatically after connection time-out in SQL Server 2016 and 2017 Q4501797 KB4501797 January 20, 2021
• 4501741 FIX: URL encoding is incorrect when the Excel workbook name is in Russian language in SSRS 2016 Q4501741 KB4501741 January 20, 2021
• 4500770 FIX: AG is suspended when cross-database transaction is applied on AG databases in SQL Server 2016 and 2017 Q4500770 KB4500770 January 20, 2021
• 4500403 FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2014, 2016 and 2017 Q4500403 KB4500403 January 20, 2021
• 4500327 FIX: Non-yielding scheduler issue occurs when you run queries in batch mode that spill in SQL Server 2016 and 2017 Q4500327 KB4500327 January 20, 2021
• 4499231 FIX: Log reader agent may fail after AG failover with TF 1448 enabled in SQL Server 2014, 2016 and 2017 Q4499231 KB4499231 January 20, 2021
• 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 January 20, 2021
• 4497230 FIX: Fail to join the secondary replica if the database has a defunct filegroup in SQL Server 2014, 2016 and 2017 Q4497230 KB4497230 January 20, 2021
• 4497225 FIX: Query against table with both clustered columnstore index and nonclustered rowstore index may return incorrect results in SQL Server 2016 and 2017 Q4497225 KB4497225 January 20, 2021
• 4495663 FIX: Error 41162 occurs when the creation of distributed availability groups fails in SQL Server 2016 and 2017 Q4495663 KB4495663 January 20, 2021
• 4495547 FIX: Remote ad hoc queries that use OPENDATASOURCE produce an incorrect error message when the new OLE DB provider is used Q4495547 KB4495547 January 20, 2021
• 4493765 FIX: HTML files cannot be opened directly from the web portal in SSRS 2016 Q4493765 KB4493765 January 20, 2021
• 4493363 FIX: Masked data may be exposed when a query manipulates the data using a temporary table in SQL Server 2016 and 2017 Q4493363 KB4493363 January 20, 2021
• 4492899 FIX: FileTable database level directory is inaccessible after database startup in SQL Server 2016 and 2017 Q4492899 KB4492899 January 20, 2021
• 4492880 FIX: Automatic seeding assertions occur when databases are removed from AG in SQL Server 2016 and 2017 Q4492880 KB4492880 January 20, 2021
• 4492762 FIX: SQL Trace Collection Set fails when you click "Collect and Upload Now" in SQL Server 2016 Q4492762 KB4492762 January 20, 2021
• 4492604 FIX: Manual failover between forwarder and secondary replica fails with all replicas synchronized in SQL Server 2016 and 2017 Q4492604 KB4492604 January 20, 2021
• 4491696 FIX: Floating point exception error 3628 occurs when you query DMV sys.dm_db_xtp_hash_index_stats in SQL Server 2016 Q4491696 KB4491696 January 20, 2021
• 4490435 FIX: "The given key was not present in the dictionary" occurs if you do a preview in the CDC Source in SQL Server 2016 Q4490435 KB4490435 January 20, 2021
• 4490237 FIX: Restoring backup to SQL Server 2016 and 2017 from SQL Server 2008 or 2008 R2 takes a long time Q4490237 KB4490237 January 20, 2021
• 4490136 FIX: Assertion error occurs when you use sys.dm_exec_query_statistics_xml in SQL Server 2016 and 2017 Q4490136 KB4490136 January 20, 2021
• 4489202 FIX: Error 10314 occurs when you load .NET CLR assembly in SQL Server 2016 and 2017 database Q4489202 KB4489202 January 20, 2021
• 4489150 FIX: Filtered index may be corrupted when you rebuild index in parallel in SQL Server 2014, 2016 and 2017 Q4489150 KB4489150 January 20, 2021
• 4488971 FIX: MDS database upgrade fails with error in SQL Server 2016 and 2017 Q4488971 KB4488971 January 20, 2021
• 4488949 FIX: Assertion occurs when linked server which points to itself is used in a cross-database transaction in SQL Server 2016 and 2017 Q4488949 KB4488949 January 20, 2021
• 4488856 FIX: Error 2812 and 20028 occur when you drop publisher or enable database for publication after you upgrade your SQL Server 2016 and 2017 Q4488856 KB4488856 January 20, 2021
• 4488853 FIX: 'MSrepl_agent_jobs' does not exist when you run sp_addpullsubscription_agent to create pull subscription in SQL Server 2016 and 2017 Q4488853 KB4488853 January 20, 2021
• 4488817 FIX: FILESTREAM for file I/O access feature can't be enabled when you use Cluster Shared Volumes (CSV) in SQL Server 2016 and 2017 Failover Cluster Instances Q4488817 KB4488817 January 20, 2021
• 4488809 FIX: Assertion occurs when a parallel query deletes from a Filestream table in SQL Server 2014, 2016 and 2017 Q4488809 KB4488809 January 20, 2021
• 4488036 FIX: Repl_Schema_Access wait issues when there are multiple publisher databases on the same instance of SQL Server 2016 and 2017 Q4488036 KB4488036 January 20, 2021
• 4487094 FIX: Delays when Query Store Async Load is enabled in SQL Server 2016 Q4487094 KB4487094 January 20, 2021
• 4486940 FIX: Assertion failure occurs when you try to back up database in limited disk space in SQL Server 2016 and 2017 Q4486940 KB4486940 January 20, 2021
• 4486937 FIX: Publishing MDS data from Excel fails when you save the changes to workbook, close and reopen it in SQL Server 2016 and 2017 Q4486937 KB4486937 January 20, 2021
• 4486935 FIX: Query results are not as expected when you run a particular query from Excel in SQL 2014 SP2 CU14 or later version (2016, 2017 or 2019) Q4486935 KB4486935 January 20, 2021
• 4486932 FIX: Users are incorrectly permitted to create incremental statistics on nonclustered indexes which are not aligned to the base table in SQL Server 2016 and 2017 Q4486932 KB4486932 January 20, 2021
• 4486852 FIX: Access violation when you run a query that contains a batch-mode hash join on Clustered Columnstore Index table in SQL Server 2016 Q4486852 KB4486852 January 20, 2021
• 4483571 FIX: Possible assertion failure when a cross-database transaction involving an Availability Group database is committed from a SQL Server trigger Q4483571 KB4483571 January 20, 2021
• 4483427 FIX: Access violation occurs and server stops unexpectedly when you use XEvent session with sqlos.wait_info event in SQL Server Q4483427 KB4483427 January 20, 2021
• 4480709 FIX: Error 18204 during automatic backup in virtual machines when the backup file is split into multiple files Q4480709 KB4480709 January 20, 2021
• 4480650 FIX: sys.fn_hadr_backup_is_preferred_replica returns TRUE for more than one secondary replica even if the priority values are identical in SQL Server 2016 and 2017 Q4480650 KB4480650 January 20, 2021
• 4480648 FIX: ObjectPropertyEx returns incorrect row count when there are partitions in a database object Q4480648 KB4480648 January 20, 2021
• 4480641 FIX: Columnstore Index build request may time out after 25 seconds though the memory grant time-out is configured in SQL Server 2016 or 2017 Q4480641 KB4480641 January 20, 2021
• 4480640 FIX: Server crashes when you cancel DBCC CHECKDB against a large database in SQL Server 2016 Q4480640 KB4480640 January 20, 2021
• 4480639 FIX: SQL Server service crashes when DBCC CHECKDB runs against a database that has a corrupted partition Q4480639 KB4480639 January 20, 2021
• 4480635 FIX: High CPU usage when there are many batch requests in SQL Server Q4480635 KB4480635 January 20, 2021
• 4479283 FIX: SQL Server installation fails if one of the remote nodes is unreachable in a cluster Q4479283 KB4479283 January 20, 2021
• 4469942 FIX: Sharing violation when the "sp_cycle_agent_errorlog" stored procedure is run in SQL Server Q4469942 KB4469942 January 20, 2021
• 4469908 FIX: Error 3961 occurs when you use Application roles for the second time in read-only secondary replicas in SQL Server 2016 AG Q4469908 KB4469908 January 20, 2021
• 4469349 FIX: VSS backup fails in SQL Server 2008 after you install CU10 for SQL Server 2016 SP1 in the same virtual machine Q4469349 KB4469349 January 20, 2021
• 4469292 FIX: Cannot connect to the MDS database by using the MDS Add-in for Microsoft Excel Q4469292 KB4469292 January 20, 2021
• 4469268 FIX: I/O error on a BPE file causes buffer time-out in SQL Server Q4469268 KB4469268 January 20, 2021
• 4468102 FIX: Excessive memory usage when you trace RPC events that involve Table-Valued Parameters in SQL Server 2016 and 2017 Q4468102 KB4468102 January 20, 2021
• 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 January 20, 2021
• 4467006 FIX: The schedule changes to "Report-specific schedule" when you enable "Create cache snapshots on a schedule" for the report in SSRS 2016 Q4467006 KB4467006 January 20, 2021
• 4466994 FIX: "3414" and "9003" errors and a .pmm log file grows large in SQL Server 2016 and 2017 Q4466994 KB4466994 January 20, 2021
• 4466831 FIX: “A connection cannot be made” error when SSIS package uses a parameterized connection manager in SQL Server 2016 and 2017 Q4466831 KB4466831 January 20, 2021
• 4466793 FIX: Assertion error occurs when you restart the SQL Server 2016 database Q4466793 KB4466793 January 20, 2021
• 4466108 FIX: Backing up a SQL Server database by using a VSS backup application may fail after installing SQL Server 2016 and 2017 Q4466108 KB4466108 January 20, 2021
• 4466107 FIX: Encryption scan task triggered upon the startup of a database may be canceled in SQL Server 2016 Q4466107 KB4466107 January 20, 2021
• 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 January 20, 2021
• 4465249 FIX: “ORA-01036: illegal variable name/number” when you query an Oracle database in SSAS 2016 Q4465249 KB4465249 January 20, 2021
• 4465236 FIX: Access violation occurs in compile code when you parse the forced plan in SQL Server 2016 and 2017 Q4465236 KB4465236 January 20, 2021
• 4463125 FIX: Error occurs when the Database Encryption Key is longer than 3,456 bits in SQL Server 2016 and 2017 Q4463125 KB4463125 January 20, 2021
• 4462481 FIX: Query operation freezes when you insert data into a clustered columnstore index in parallel in SQL Server data warehousing Q4462481 KB4462481 January 20, 2021
• 4460116 FIX: Overestimations when using default Cardinality Estimator to query table with many null values Q4460116 KB4460116 January 20, 2021
• 4459981 FIX: Access violation occurs and SSAS crashes when you process an SSAS database in SQL Server 2014, 2016 and 2017 Q4459981 KB4459981 January 20, 2021
• 4459327 FIX: Error 41317 when you enable server audit and you use in-memory transactions in SQL Server Q4459327 KB4459327 January 20, 2021
• 4458880 FIX: “9003 error, sev 20, state 1” error when a backup operation fails on a secondary replica that is running under asynchronous-commit mode Q4458880 KB4458880 January 20, 2021
• 4458438 FIX: The SQL Service shuts down after SP2 is installed on SQL Server 2016 and 2017 with c2 audit mode enabled Q4458438 KB4458438 January 20, 2021
• 4456883 FIX: Change Tracking cleanup message 22123 is unexpectedly recorded in the error log file in SQL Server Q4456883 KB4456883 January 20, 2021
• 4456775 FIX: Can't retrieve ConnectionID and SPID when running an SSAS Profiler trace in SQL Server Q4456775 KB4456775 January 20, 2021
• 4347088 FIX: Out of memory error occurs even when there are many free pages in SQL Server Q4347088 KB4347088 January 20, 2021
• 4341221 FIX: VSS backup fails in secondary replica of Basic Availability Groups in SQL Server 2016 and 2017 Q4341221 KB4341221 January 20, 2021
• 4339858 FIX: Parallel redo does not work after you disable Trace Flag 3459 in an instance of SQL Server Q4339858 KB4339858 January 20, 2021
• 4338746 FIX: Error 19432 when you use Always On Availability Groups in SQL Server Q4338746 KB4338746 January 20, 2021
• 4338636 FIX: SQL jobs fail due to blocking in SSISDB in SQL Server 2014, 2016 and 2017 Q4338636 KB4338636 January 20, 2021
• 4338576 FIX: Transaction delays on the primary replica if database synchronization is reported incorrectly on a secondary replica in SQL Server Q4338576 KB4338576 January 20, 2021
• 4338240 FIX: Toggle item, font color, and background color expressions do not work correctly together in SSRS Q4338240 KB4338240 January 20, 2021
• 4338204 FIX: Circular dependency between column names for a calculated table that summarizes the partition query dataset in SQL Server Q4338204 KB4338204 January 20, 2021
• 4316948 FIX: Access violation when you compile a query and histogram amendment is enabled with default Cardinality Estimation in SQL Server 2016 and 2017 Q4316948 KB4316948 January 20, 2021
• 4294694 FIX: Access violation when you try to access a table when page compression is enabled on the table in SQL Server Q4294694 KB4294694 January 20, 2021
• 4230516 FIX: A memory assertion failure occurs, and the server can't make new connections in SQL Server Q4230516 KB4230516 January 20, 2021
• 4163478 FIX: An access violation occurs when incremental statistics are automatically updated on a table in SQL Server Q4163478 KB4163478 January 20, 2021
• 4157948 FIX: Floating point overflow error when you run a nested natively compiled module that uses EXP functions in SQL Server Q4157948 KB4157948 January 20, 2021
• 4133191 FIX: A memory leak occurs in sqlwepxxx.dll causes the WmiPrvSe.exe process to crash Q4133191 KB4133191 January 20, 2021
• 4131251 FIX: Thai characters in SSAS for SQL Server exported to a PDF file are displayed incorrectly Q4131251 KB4131251 January 20, 2021
• 4101554 FIX: Parallel redo in a secondary replica of an availability group that contains heap tables generates a runtime assert dump or the SQL Server crashes with an access violation error Q4101554 KB4101554 January 20, 2021
• 4101502 FIX: TDE-enabled database backup with compression causes database corruption in SQL Server Q4101502 KB4101502 January 20, 2021
• 4094893 FIX: Database can't be dropped after its storage is disconnected and reconnected in SQL Server Q4094893 KB4094893 January 20, 2021
• 4094858 FIX: “An unexpected error occurred” when you use DAX measures in Power BI table visualizations in SQL Server Q4094858 KB4094858 January 20, 2021
• 4093226 FIX: “DirectQuery may not be used with this data source” error when you browse a Direct Query model in SQL Server Q4093226 KB4093226 January 20, 2021
• 4089099 FIX: It takes a long time to restore a TDE-encrypted database backup in SQL Server Q4089099 KB4089099 January 20, 2021
• 4088901 FIX: Assertion failure when sys.dm_db_log_space_usage statement is run on a database snapshot in SQL Server 2016 and 2017 Q4088901 KB4088901 January 20, 2021
• 4087406 FIX: Error 9002 when there is no sufficient disk space for critical log growth in SQL Server 2014, 2016, and 2017 Q4087406 KB4087406 January 20, 2021
• 4086173 FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services Q4086173 KB4086173 January 20, 2021
• 4082865 FIX: SSAS crashes when a query is executed on a large partitioned table in SQL Server 2016 Q4082865 KB4082865 January 20, 2021
• 4077683 FIX: System stored procedure sp_execute_external_script and DMV sys.dm_exec_cached_plans cause memory leaks in SQL Server 2016 and 2017 Q4077683 KB4077683 January 20, 2021
• 4074881 FIX: Assertion error when data is bulk-inserted into a table that contains non-clustered and clustered columnstore indexes in SQL Server 2016 and 2017 Q4074881 KB4074881 January 20, 2021
• 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 January 20, 2021
• 4058700 FIX: Intermittent 9004 error when a backup is restored via Standby Mode in SQL Server 2014, 2016, and 2017 Q4058700 KB4058700 January 20, 2021
• 4058565 FIX: Assertion error when executing a stored procedure that references a large object in SQL Server 2014, 2016, and 2017 Q4058565 KB4058565 January 20, 2021
• 4057307 FIX: Multidimensional mode randomly crashes and an access violation occurs in SSAS 2016 or in SSAS 2014 Q4057307 KB4057307 January 20, 2021
• 4053693 FIX: CDC components in SSIS do not function in SQL Server after a cumulative update is applied Q4053693 KB4053693 January 20, 2021
• 4052633 FIX: SELECT query that uses batch mode hash aggregate operator that counts multiple nullable columns returns bad results in SQL Server Q4052633 KB4052633 January 20, 2021
• 4052625 FIX: Queries that retrieve data by using non-clustered index seek take longer in SQL Server Q4052625 KB4052625 January 20, 2021
• 4052135 FIX: RESTORE HEADERONLY statement for a TDE compressed backup slow to complete in SQL Server Q4052135 KB4052135 January 20, 2021
• 4052127 FIX: Alert Engine reads complete Application event log and sends alerts on old events after Windows is restarted Q4052127 KB4052127 January 20, 2021
• 4051359 FIX: SQL Server runs out of memory when table-valued parameters are captured in Extended Events sessions in SQL Server 2016 even if collecting statement or data stream isn't enabled Q4051359 KB4051359 January 20, 2021
• 4046885 FIX: The SQL Server 2016 setup page contains nonsecure tool-download links Q4046885 KB4046885 January 20, 2021
• 4046858 FIX: Parallel query execution plan with "merge join" slow to execute in Cumulative Update 3, 4, or 5 for SQL Server 2016 Service Pack 1 Q4046858 KB4046858 January 20, 2021
• 4042962 FIX: "An unknown error" for "Show More Members" on Entity Dependencies explorer page in SQL Server 2016 and 2017 Master Data Services Q4042962 KB4042962 January 20, 2021
• 4040539 FIX: Error when using sp_execute_external_script stored procedure to insert data and specify @parallel value to 1 in SQL Server 2016 Q4040539 KB4040539 January 20, 2021
• 4040014 FIX: Query that joins a view and contains UNION ALL slow in SQL Server 2016 Q4040014 KB4040014 January 20, 2021
• 4039735 FIX: "Non-yielding Scheduler" condition occurs for query with many expressions in SQL Server 2014 and 2016 Q4039735 KB4039735 January 20, 2021
• 4025628 FIX: Error 9004 when you try to restore a compressed backup from multiple files for a large TDE-encrypted database in SQL Server Q4025628 KB4025628 January 20, 2021
• 4025021 FIX: Blank spaces in the parameter area when you open SSRS report that contains Hidden or Internal parameters in SQL Server 2016 Q4025021 KB4025021 January 20, 2021
• 4024989 FIX: "EXCEPTION_INVALID_CRT_PARAMETER" error with BULK INSERT statement in SQL Server 2016 Q4024989 KB4024989 January 20, 2021
• 4024392 FIX: "Non-yielding Scheduler" condition occurs when you change the BUCKET_COUNT value for large memory-optimized tables in Microsoft SQL Server 2016 Q4024392 KB4024392 January 20, 2021
• 4024184 FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016 Q4024184 KB4024184 January 20, 2021
• 4023679 FIX: Timeout when you back up a large database to URL in SQL Server 2014 or 2016 Q4023679 KB4023679 January 20, 2021
• 4023138 FIX: "Incorrect syntax" error when you add a subscription by using the "sp_addpullsubscription_agent" stored procedure in SQL Server Q4023138 KB4023138 January 20, 2021
• 4022874 FIX: The FILESTREAM feature in SQL Server is disabled after you install Windows 10 Creators Update Q4022874 KB4022874 January 20, 2021
• 4021405 FIX: An access violation occurs when you create an index with page compression in SQL Server Q4021405 KB4021405 January 20, 2021
• 4020747 FIX: SQL Server 2016 crashes with an access violation in sqlmin!TListElem when you execute R scripts Q4020747 KB4020747 January 20, 2021
• 4019983 FIX: "Index was out of range" error when exporting to PDF in a SQL Server Reporting Services report Q4019983 KB4019983 January 20, 2021
• 4019978 FIX: "Error occurred during rendering" when you export a report as a PowerPoint presentation in SQL Server 2016 Reporting Services Q4019978 KB4019978 January 20, 2021
• 4019863 FIX: Assertion occurs when you run an ALTER TABLE SWITCH statement on a partitioned temporal history table in SQL Server 2016 Q4019863 KB4019863 January 20, 2021
• 4019715 FIX: SQL Server 2016 does not log error messages that have a severity level of 21 for checksum mismatches found in In-Memory OLTP checkpoint files Q4019715 KB4019715 January 20, 2021
• 4019603 FIX: SSAS crashes when an MDX query that refers to parent-child dimensions runs in SQL Server 2014 or 2016 Q4019603 KB4019603 January 20, 2021
• 4019446 FIX: SQL Server 2016 stops responding when the "Latch_Suspend_End" extended event is incorrectly triggered Q4019446 KB4019446 January 20, 2021
• 4019286 FIX: SQL Server 2016 Reporting Service subscription incorrectly sends a PDF attachment as an "Application/Octet-Stream" MIME type Q4019286 KB4019286 January 20, 2021
• 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 January 20, 2021
• 4018227 FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server Q4018227 KB4018227 January 20, 2021
• 4016853 FIX: Deadlock when apps try to acquire or refresh an authentication token through Azure Key Vault Provider for Always Encrypted Q4016853 KB4016853 January 20, 2021
• 4016805 FIX: The SQL Server Analysis Service encounters an internal error when it processes a Tabular model Q4016805 KB4016805 January 20, 2021
• 4016804 FIX: Deadlocks occur in SSISDB when you run multiple SSIS packages in SQL Server 2014 or 2016 Q4016804 KB4016804 January 20, 2021
• 4016238 FIX: DBCC CLONEDATABASE is unsuccessful if the source database has an object originally created in SQL Server 2000 Q4016238 KB4016238 January 20, 2021
• 4014719 FIX: "(0x80004002) No such interface supported" error when you use RMO to run Web Synchronization for Merge Replication in SQL Server 2016 Q4014719 KB4014719 January 20, 2021
• 4014706 FIX: Failed assertion and many access violation dump files after the sp_replcmds stored procedure is canceled in SQL Server Q4014706 KB4014706 January 20, 2021
• 4014031 FIX: Incorrect data when a subscription runs on a computer whose time zone differs from the report server time zone in SQL Server 2016 Reporting Services Q4014031 KB4014031 January 20, 2021
• 4014013 FIX: Unexpected error occurs when you process a table in a tabular model in SSAS 2016 Q4014013 KB4014013 January 20, 2021
• 4013585 FIX: SQL Server Analysis Service proactive caching processes a partition but doesn't run an SQL query, causing stale data Q4013585 KB4013585 January 20, 2021
• 4013207 FIX: "Incorrect syntax for definition of the 'default' constraint" error when you add an arbitrary columnstore column in SQL Server 2016 Q4013207 KB4013207 January 20, 2021
• 4013206 FIX: SQL Server 2016 Analysis Services crashes or hangs during processing of data in a Tabular instance Q4013206 KB4013206 January 20, 2021
• 4013124 FIX: An access violation occurs when natively compiled stored procedures are executed concurrently in SQL Server 2016 Q4013124 KB4013124 January 20, 2021
• 4013119 FIX: DBCC CLONEDATABASE doesn't copy the runtime cache of the query store to the clone in SQL Server 2016 SP1 Q4013119 KB4013119 January 20, 2021
• 4013118 FIX: The sys.column_store_segments catalog view displays incorrect values in the column_id column in SQL Server 2016 Q4013118 KB4013118 January 20, 2021
• 4013116 FIX: ALTER TABLE, ADD CONSTRAINT, and PRIMARY KEY statements do not detect a duplicate key in SQL Server 2016 Q4013116 KB4013116 January 20, 2021
• 4013115 FIX: CREATE OR ALTER statement applied on a DDL trigger fails on the next execution in SQL Server 2016 Q4013115 KB4013115 January 20, 2021
• 4013112 FIX: "ADD PERIOD FOR SYSTEM_TIME failed" error when you add period columns to a memory-optimized table in SQL Server 2016 Q4013112 KB4013112 January 20, 2021
• 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 January 20, 2021
• 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 January 20, 2021
• 4010990 FIX: SQL Server is stopped when you install patches on an instance of SQL Server that contains many databases Q4010990 KB4010990 January 20, 2021
• 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 January 20, 2021
• 4010162 FIX: A system assert occurs when a Transact-SQL stored procedure with a TVP argument is called from a SQLCLR procedure Q4010162 KB4010162 January 20, 2021
• 4010159 FIX: "Invoke-sqlcmd" cmdlet executes a query statement multiple times if an error occurs in SQL Server 2014 or 2016 Q4010159 KB4010159 January 20, 2021
• 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 January 20, 2021
• 4009624 FIX: Audit calls trigger asserts when you create or drop external tables in SQL Server 2016 Q4009624 KB4009624 January 20, 2021
• 3212318 FIX: Can't set a database to partial containment if SQL Server change tracking was ever enabled on that database Q3212318 KB3212318 January 20, 2021
• 3195752 FIX: Wrong number of rows returned in sys.partitions for Columnstore index in SQL Server 2016 Q3195752 KB3195752 January 20, 2021
• 4040401 FIX: Access violation for spatial datatypes query via linked server in SQL Server Q4040401 KB4040401 January 14, 2021
• 4024840 FIX: Access violation occurs when trace flag 176 enabled in SQL Server 2016 Q4024840 KB4024840 January 14, 2021
• 4022435 FIX: Parallel query execution returns incorrect results for merge join operations in SQL Server 2016 Q4022435 KB4022435 January 14, 2021
• 4016850 FIX: Incorrect results when you use SQL Server Management Objects to generate a script for a full-text Search index Q4016850 KB4016850 January 14, 2021
• 4013999 FIX: Significantly increased PAGELATCH_EX contentions in sys.sysobjvalues in SQL Server 2016 Q4013999 KB4013999 January 14, 2021
• 4038932 FIX: Change Data Capture functionality does not work in SQL Server Q4038932 KB4038932 December 24, 2020
• 4560494 FIX: MDX queries with calculated measure using the "/" operator run slow in SSAS Q4560494 KB4560494 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
• 4016657 FIX: Bad query plan created on secondary replicas after FULLSCAN statistics update on primary replica in SQL Server 2016 SP1 Q4016657 KB4016657 October 23, 2020
• 4016655 FIX: Bad query plan created on secondary replicas after FULLSCAN statistics update on primary replica in SQL Server 2016 Q4016655 KB4016655 October 23, 2020
• 4541550 FIX: UDF Scalar-Valued-Function may take longer and consume more CPU in SQL Server 2016 Q4541550 KB4541550 February 25, 2020
• 4502458 FIX: Running RESTORE VERIFYONLY logs a CREATE DATABASE event in a server audit specification that uses DATABASE_CHANGE_GROUP in SQL Server Q4502458 KB4502458 May 15, 2019
• 4491333 FIX: Subscription will fail if the DateTime parameter is created and edited by different locale and keyboard language in SSRS 2016 Q4491333 KB4491333 March 19, 2019
• 4490743 FIX: Simple Data Grid row header disappears when an item within the grid is clicked in SSRS 2016 Q4490743 KB4490743 March 19, 2019
• 4490737 FIX: Unable to edit a Data-Driven subscription with date parameter in SSRS 2016 Q4490737 KB4490737 March 19, 2019
• 4488403 FIX: Images in the report will not display when the report name contains a bracket "(" in SSRS 2016 Q4488403 KB4488403 March 19, 2019
• 4486939 FIX: Access violation occurs when SQL is trying to promote a transaction to DTC while collecting QDS statistics Q4486939 KB4486939 January 23, 2019
• 4480795 FIX: An unexpected error occurs when you run an MDX query against an Excel pivot table in SSAS 2016 Q4480795 KB4480795 January 23, 2019
• 4480654 FIX: Large white space appears between the textbox and tablix when a report is viewed by using SSRS 2016 Report Manager Q4480654 KB4480654 January 23, 2019
• 4470528 FIX: Nested tablix shows small font or partial text in SSRS 2016 and later versions Q4470528 KB4470528 January 23, 2019
• 4463328 FIX: “An unexpected exception occurred” when you run an MDX query after an XMLA query to process a dimension in SSAS Q4463328 KB4463328 January 23, 2019
• 4459535 FIX: Masked data is exposed when a query that uses sp_cursorfetch is run in SQL Server if Dynamic Data Masking is enabled Q4459535 KB4459535 January 23, 2019
• 4483881 FIX: Primary replica will be unreachable when you use constant stream of new connections to connect to database in Read-Only Routing enabled AG in SQL Server Q4483881 KB4483881 January 21, 2019
• 4340986 FIX: Access violation in cross data center failover if you use Always On Availability Groups in SQL Server Q4340986 KB4340986 December 18, 2018
• 4468869 FIX: Relationships not working correctly on synchronized tabular database Q4468869 KB4468869 November 13, 2018
• 4465747 FIX: Snapshot Agent fails when publishing many tables using snapshot or transactional replication Q4465747 KB4465747 November 13, 2018
• 4465476 FIX: Errors when changing filters in Excel or PBI reports after model is updated in SSAS Q4465476 KB4465476 November 13, 2018
• 4459682 FIX: Duplicate week entry displayed in SSRS 2016 mobile report if the week starts on Monday Q4459682 KB4459682 September 20, 2018
• 4294660 FIX: SSAS stops responding when you run MDX queries and DirectQuery mode is enabled in SQL Server Q4294660 KB4294660 September 20, 2018
• 4135045 FIX: DROP_ASYMMETRIC_KEY causes SQL Server crash if rolled back from trigger Q4135045 KB4135045 September 20, 2018
• 4340426 FIX: The Excel Add-in still appears on the MDS home page when the option is set to “No” in MDS Configuration Manager Q4340426 KB4340426 August 27, 2018
• 4337554 FIX: SSAS service crashes when you use the “Connect live” option in Power BI Desktop Q4337554 KB4337554 August 15, 2018
• 4133164 FIX: Error when a SQL Server Agent job runs a PowerShell command to enumerate permissions of the database Q4133164 KB4133164 July 18, 2018
• 4340342 FIX: Query on a secondary replica takes two times as long as on a primary replica in SQL Server Q4340342 KB4340342 July 16, 2018
• 4134541 FIX: Error in MDS Add-in for Excel when using German Excel in SQL Server Q4134541 KB4134541 June 27, 2018
• 4162814 FIX: Internal exception access violation, SSAS server stops responding Q4162814 KB4162814 June 21, 2018
• 4134175 FIX: Processing cube with many partitions generates many concurrent data source connections in SSAS Q4134175 KB4134175 June 21, 2018
• 4293839 FIX: TDE database goes offline during log flush if you lose connection to the EKM provider in SQL Server Q4293839 KB4293839 June 18, 2018
• 4230306 FIX: Restore of TDE-compressed backup via VDI client is unsuccessful Q4230306 KB4230306 May 30, 2018
• 4132267 FIX: Deploying a SSAS project in SSDT is frequently unsuccessful in SQL Server Analysis Services in Tabular mode Q4132267 KB4132267 May 30, 2018
• 4098762 FIX: Hidden parameters included in reports when Browser role used in SSRS 2016 Q4098762 KB4098762 May 30, 2018
• 4089509 FIX: Access Violation when you use QDS and specify a query plan to resolve a performance regression Q4089509 KB4089509 April 24, 2018
• 4075158 FIX: Booleans localized incorrectly in report parameters in SSRS 2016 (SharePoint mode) Q4075158 KB4075158 April 23, 2018
• 4046902 FIX: "TempDB file size exceeds 1024 MB" error when you try to set the initial size for a TempDB file to a value greater than 1,024 MB Q4046902 KB4046902 April 23, 2018
• 4090025 FIX: Random masking does not mask BIGINT values correctly in SQL Server Q4090025 KB4090025 April 18, 2018
• 4077708 FIX: Assert in "HadrRefcountedObject::Release" when replica configured for manual seeding in SQL Server Q4077708 KB4077708 April 18, 2018
• 4103833 FIX: Q4103833 KB4103833 April 3, 2018
• 4019671 FIX: Severe error when you create a spatial index by using the GEOMETRY_GRID or GEOGRAPHY_GRID option in SQL Server Q4019671 KB4019671 March 25, 2018
• 4090137 FIX: KPI trend line not correct when shared dataset cache updated in SQL Server Q4090137 KB4090137 March 23, 2018
• 4089171 FIX: PolyBase Engine startup crash if performance counters missing from Windows Performance Monitor Q4089171 KB4089171 March 23, 2018
• 4089095 FIX: Bad MDX query results after restoring tabular db in SQL Server Q4089095 KB4089095 March 23, 2018
• 4074696 FIX: Drillthrough operation fails and returns an error for row-level non-administrators in SSAS 2016 (Tabular model) Q4074696 KB4074696 March 19, 2018
• 4052121 FIX: Access violation for DMV queries run against a distributed availability group in SQL Server Q4052121 KB4052121 February 20, 2018
• 4040934 FIX: SQL Server Integration Service packages randomly hang if custom logging is enabled Q4040934 KB4040934 February 20, 2018
• 4082888 FIX: Error occurs when you install SQL Server 2016 on a Cluster Shared Volume disk Q4082888 KB4082888 February 12, 2018
• 4045273 Full-text indexes stop populating for 30 minutes in SQL Server Q4045273 KB4045273 February 2, 2018
• 4052132 FIX: Non-yielding scheduler error when using SQL Server Query Store in SQL Server Q4052132 KB4052132 November 22, 2017
• 4043459 FIX: Remote instance of SQL Server crashes when a stored procedure bulk loads an incomplete data file into a temporary table Q4043459 KB4043459 October 24, 2017
• 4043103 FIX: Load data from staging tables takes a much longer time to finish when recursive hierarchy is used in Master Data Services Q4043103 KB4043103 October 24, 2017
• 4022594 FIX: Incorrect MDX query results if a table cross join is run on a table hierarchy member in SSAS Q4022594 KB4022594 October 24, 2017
• 4021994 FIX: SSAS crashes when a measure is added that refers to null values in Power BI Q4021994 KB4021994 October 24, 2017
• 4017827 FIX: Reporting Services "SortExpression" cause rsComparisonError when there is a NULL value in a column set as "DataTimeOffset" Q4017827 KB4017827 October 24, 2017
• 3212541 FIX: SSAS crashes when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase Q3212541 KB3212541 October 24, 2017
• 3108537 FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server Q3108537 KB3108537 September 18, 2017
• 4024868 FIX: Assertion failure when backing up large TDE encrypted database in SQL Server Q4024868 KB4024868 August 8, 2017
• 4024126 FIX: Access violation in sqllang.dll after upgrading to SQL Server 2016 SP1 Q4024126 KB4024126 August 8, 2017
• 4024125 FIX: After upgrade to SQL Server 2016 SP1, an access violation occurs in sqlmin.dll when querying against a Columnstore index Q4024125 KB4024125 August 8, 2017
• 4019048 FIX: SSAS crashes when you retrieve KPIs as hidden members by using schema rowsets in SQL Server Q4019048 KB4019048 August 8, 2017
• 4019988 FIX: Access violation and SSAS 2016 crashes when many partitions and their aggregations or indexes are processed concurrently Q4019988 KB4019988 May 15, 2017
• 4019097 FIX: Error 608 when a stored procedure that inserts rows into a temporary table that has a spatial index is run in SQL Server Q4019097 KB4019097 May 15, 2017
• 4018741 FIX: MDX query returns an error in SQL Server Analysis Service if the dimension table contains members that do not exist in the fact table Q4018741 KB4018741 May 15, 2017
• 4017013 FIX: Large memory allocations of type MEMOBJ_XSTMT occur when you run the sys.dm_exec_query_stats script in SQL Server Q4017013 KB4017013 May 15, 2017
• 4016613 FIX: Reporting Services web portal stops responding when you edit a subscription if a parameter has many available values in SQL Server Q4016613 KB4016613 May 15, 2017
• 4013609 FIX : Cannot sort subscriptions by column in SSRS 2016 web portal Q4013609 KB4013609 May 15, 2017
• 3197976 FIX: Transactions are not recorded after you deactivate leaf members in a staging table in Master Data Services Q3197976 KB3197976 May 15, 2017
• 4013110 FIX: SSRS 2016 mobile report that contains a shared dataset times out and does not load Q4013110 KB4013110 March 20, 2017
• 3198775 FIX: Inefficient query plan is used for a query requiring order by partitioning column of a table with single partition Q3198775 KB3198775 March 10, 2017
• 4013127 FIX: R Client 3.3.2 does not connect to Microsoft R Server on a Hadoop cluster by using PuTTY Q4013127 KB4013127 February 22, 2017
• 3206912 FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks Q3206912 KB3206912 February 21, 2017
• 3212252 FIX: Parameter values aren't contained in the URL when the parameter is used multiple times in a drillthrough custom URL Q3212252 KB3212252 January 18, 2017
• 3211220 FIX: KPIs bound to a dataset together with parameters are not updated during cache refresh Q3211220 KB3211220 January 18, 2017
• 3213778 FIX: MDS business rule does not trigger on an attribute value change if the attribute belongs to a change tracking group Q3213778 KB3213778 January 17, 2017
• 3213496 FIX: Cannot save a subscription when you browse to SSRS 2016 web portal by using Internet Explorer Q3213496 KB3213496 January 17, 2017
• 3210652 FIX: Automatic update of statistics feature doesn't run after you truncate a table that has a clustered columnstore index Q3210652 KB3210652 January 17, 2017
• 3210262 FIX: Version of R Client is incompatible with the Microsoft R server version 8.0.3 Q3210262 KB3210262 December 16, 2016
• 3198846 FIX: Poor table scan performance when a query filters non-Primary Key columns on in-memory history tables Q3198846 KB3198846 November 18, 2016
• 3197817 FIX: Error when you process a calculated column in a table with multiple partitions Q3197817 KB3197817 November 17, 2016
• 3190222 FIX: The user interface of SSRS 2016 mobile report contains multiple minimal display issues Q3190222 KB3190222 November 17, 2016
• 3112704 FIX: Missing columns aren't specified in the error message when you import data by using the Import and Export Wizard Q3112704 KB3112704 November 16, 2016
• 3177666 FIX: Cannot create or manage data alert for a report if the report name or folder name contains a comma in SSRS Q3177666 KB3177666 October 18, 2016
• 3188980 FIX: Duplicate mobile reports and KPIs are displayed in Power BI Mobile app Q3188980 KB3188980 September 22, 2016
• 3160427 FIX: Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format Q3160427 KB3160427 September 22, 2016
• 3145492 FIX: XA transactions aren't cleaned when you exit a Java application in an instance of SQL Server Q3145492 KB3145492 August 16, 2016
• 3174396 FIX: Counters for job objects created by SQL Server Trusted Launchpad are not visible in Windows Performance Monitor Q3174396 KB3174396 July 26, 2016
• 3174076 FIX: Cannot query or migrate data from a local Stretch-enabled table after you execute sys.sp_rda_reconcile_batch Q3174076 KB3174076 July 26, 2016
• 3174669 FIX: Infinite recompile occurs when querying a view that references the identity column of a system-versioned temporal table Q3174669 KB3174669 July 25, 2016
• 3174073 FIX: All data goes to deltastores when you bulk load data into a clustered columnstore index under memory pressure Q3174073 KB3174073 July 25, 2016
• 3173046 FIX: Localized user interface of SSRS 2016 web portal doesn't work correctly in Internet Explorer and Microsoft Edge Q3173046 KB3173046 July 25, 2016
• 3172960 FIX: Online index operations block DML operations when the database contains a clustered columnstore index Q3172960 KB3172960 July 25, 2016
• 3172939 FIX: Date picker on the SSRS 2016 web portal displays invalid characters if the web browser is set to non-English Q3172939 KB3172939 July 25, 2016
• 3172732 FIX: Column becomes empty when the VerticalAlign property is set to Middle or Bottom in SSRS 2016 Q3172732 KB3172732 July 25, 2016
• 3123309 FIX: The Log Reader Agent stops intermittently and an Access Violation occurs in SQL Server Q3123309 KB3123309 July 25, 2016