Update to add a memory grant warning to the Showplan XML in SQL Server 2014 or 2016įIX: A severe error when you use the sys.dm_db_uncontained_entities DMV in SQL Server 2014 or 2016 Supports DROP TABLE DDL for articles that are included in transactional replication in SQL Server 2014 or in SQL Server 2016 SP1 Information about enabled trace flags is added to the showplan XML in SQL Server 2014 SP2 or 2016įIX: Memory grant that's required to run optimized nested loop join isn't reflected in Showplan XML in SQL Server 2014 or 2016 Update to add DMF sys.dm_db_incremental_stats_properties in SQL Server 2014 or 2016 Update to expose maximum memory enabled for a single query in Showplan XML in SQL Server 2014 or 2016 Improved diagnostics for query execution plans that involve residual predicate pushdown in SQL ServerįIX: Missing columns aren't specified in the error message when you import data by using the Import and Export WizardįIX: SQL Server Managed Backup to Windows Azure tries to back up database snapshots in SQL ServerĭMV sys.dm_os_memory_nodes returns a non-zero value for the pages_kb value for the DAC node in SQL Server 2014 "Log provider "Microsoft.LogProviderSQLServer" is not installed correctly" error when you open the Configure SSIS Logs window This list will be updated when more articles are released.įor more information about the bugs that are fixed in SQL Server 2016 SP1, go to the following Microsoft Knowledge Base articles.Įrror when you execute SSIS package on FIPS-enabled WindowsįIX: "Unable to create restore plan due to break in the LSN chain" error when you restore differential backup in SSMS In addition to the fixes that are listed in this article, SQL Server 2016 SP1 includes hotfixes that were included in SQL Server 2016 Cumulative Update 1 (CU1) to SQL Server 2016 CU3.įor more information about the cumulative updates that are available in SQL Server 2016, see SQL Server 2016 build versions.Īdditional fixes that aren't documented here may also be included in the service pack. SQL Server 2016 SP1 upgrades all editions and service levels of SQL Server 2016 to SQL Server 2016 SP1. Microsoft SQL Server 2016 service packs are cumulative updates. List of fixes included in SQL Server 2016 SP1
Note After you install the service pack, the SQL Server service version should be reflected as.
You can download SQL Server 2016 SP1 Feature Pack here. SQL Server 2016 SP1 is available for download at the SQL Server 2016 SP1 download page.
More Information How to get SQL Server 2016 SP1 It includes all the information that you previously found in the release notes and Readme.txt files.
Note This article serves as a single source of information to locate all documentation that's related to this service pack.
It describes how to get the service pack, the list of fixes that are included in the service pack, known issues, and a list of copyright attributions for the product. This article contains important information to read before you install Microsoft SQL Server 2016 Service Pack 1(SP1). SQL Server 2016 Developer SQL Server 2016 Enterprise SQL Server 2016 Enterprise Core SQL Server 2016 Express SQL Server 2016 Standard SQL Server 2016 Web More.