Optimizer row goal information in query execution plan added in SQL Server 2017 CU3 and SQL Server 2016 SP2įIX: Execution stats of scalar user-defined function is added to Showplan XML file in SQL Server 2016 SP2įIX: 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 This list will be updated when more articles are released.įor more information about the bugs that are fixed in SQL Server 2016 SP2, go to the following Microsoft Knowledge Base articles.įIX: Memory dumps generated for 'Stalled IOCP Listener' and 'non-yielding IOCP listener' after SQL Server restart In addition to the fixes that are listed in this article, SQL Server 2016 SP2 includes hotfixes that were included in SQL Server 2016 Cumulative Update 1 (CU1)to SQL Server 2016 SP1 CU8.į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 SP2 upgrades all editions and service levels of SQL Server 2016 to SQL Server 2016 SP2. Microsoft SQL Server 2016 service packs are cumulative updates. List of fixes included in SQL Server 2016 SP2 0 Microsoft SQL Server 2016 service packs are cumulative updates. Note After you install the service pack, the SQL Server service version should be. Microsoft SQL Server 2016 SP2 Feature Pack SQL Server 2016 SP2, Microsoft SQL Server 2016 SP2 Express, and Microsoft SQL Server 2016 SP2 Feature Pack are available for manual download and installation at the following Microsoft Download Center websites.

More Information How to get SQL Server 2016 SP2 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 2 (SP2).

Ms sql 2016 developer edition download