Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: SQL Server 2016 Enterprise Core

Article ID Article Title Hidden
224071 Troubleshooting SQL Server backup and restore operations
231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem
263889 How to troubleshoot blocking caused by compile locks
294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster
307487 How to shrink the tempdb database in SQL Server
307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database"
312292 How to enable replication agents for logging to output files in SQL Server
316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
321185 How to determine the version, edition, and update level of SQL Server and its components
327518 The Microsoft Support Policy for Clustered Configurations of SQL Server with Windows Server
835185 Microsoft Windows Failover cluster resource dependencies in SQL Server
870668 Reporting Services cannot run reports against Oracle databases
917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server
935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
945934 How to register Microsoft Filter Pack IFilters with SQL Server
2033238 Performance and consistency issues when certain modules are loaded into SQL Server address space
2295405 SQL Server service crashes when you run an Oracle linked server query
2681562 Using SQL Server in Windows 8 and later versions of Windows operating system
3159748 FIX: Cannot connect to a named instance after failover on a mirror server in SQL Server 2014 or 2016
3195161 Defragmenting SQL Server database disk drives
3196535 Description of the Update Cache folder in SQL Server
3199641 MS16-136: Security update for SQL Server: November 8, 2016
3204545 The .NET Framework 4.6.2 client driver for "Always Encrypted" intermittently fails during row decryption
4010261 SQL Server and Azure SQL Database improvements in handling some data types and uncommon operations
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
4014354 How to use SQL Server 2016 in FIPS 140-2-compliant mode
4014732 FIX: A memory leak in SQLWEP causes the host process Wmiprvse.exe to crash in SQL Server
4015034 FIX: An assertion occurs when you run an UPDATE statement on a clustered columnstore index in SQL Server 2016
4015561 FIX: Access violation when a stored procedure is dropped before you execute END TRY section in SQL Server
4019701 FIX: Database schema is corrupted when you restore a database from a snapshot in SQL Server
4038932 FIX: Change Data Capture functionality does not work in SQL Server
4040549 Query execution takes significantly longer on SQL Server Always On secondary replicas
4046801 “Cannot apply value 'null' to property ServerInstance" error when looking at subscription properties in SQL Server 2017 or 2016
4052134 FIX: Errors 33111 and 3013 when backing up TDE-encrypted database in SQL Server
4090966 SQL Server session hangs when you try to enable snapshot isolation in SQL Server 2016
4230836 Application event log error code 1642 even though the SQL Server update was applied successfully
4316959 Warning message that contains “HkHostBackupGetCheckpointFileInfoV2” and “1000016” is logged in the SQL Server error log
4475775 Cumulative Update 13 for SQL Server 2016 SP1
4488256 How to block the remote use of local accounts in Windows
4528065 FIX: DBCC CHECKDB with EXTENDED_LOGICAL_CHECKS fails on a table in SQL Server 2016