SQL Server 2014 Service Pack 2 release information

This article contains important information to read before you install Microsoft SQL Server 2014 Service Pack 2 (SP2). It describes how to get the service pack, the list of fixes that are included in the service pack, how to select the correct download based on your currently installed version, and a list of copyright attributions for the product.

Note This article serves as a single source of information to locate all documentation that's related to this service pack. It includes all the information that you previously found in the release notes and Readme.txt files.
More information

How to get SQL Server 2014 SP2

SQL Server 2014 SP2 is available for download at the SQL Server 2014 SP2 download page. You can download SQL Server 2014 SP2 Feature Pack here.

Note After you install the service pack, the SQL Server service version should be reflected as 12.0.5000.0.

List of fixes included in SQL Server 2014 SP2

Microsoft SQL Server 2014 service packs are cumulative updates. SQL Server 2014 SP2 upgrades all editions and service levels of SQL Server 2014 to SQL Server 2014 SP2. In addition to the fixes that are listed in this article, SQL Server 2014 SP2 includes hotfixes that were included in SQL Server 2014 SP1 CU1 to SQL Server 2014 SP1 CU7.

For more information about the cumulative updates that are available in SQL Server 2014, see SQL Server 2014 build versions.

Notes

  • Additional fixes that aren't documented here may also be included in the service pack.
  • This list will be updated when more articles are released.
For more information about the bugs that are fixed in SQL Server 2014 SP2, go to the following Microsoft Knowledge Base articles.

VSTS bug numberKB article numberDescription
56945973173766FIX: DBCC CHECKDB or CHECKTABLE returns false positives for data corruption and assertion failures in SQL Server 2014
69356553177838 DBCC CLONEDATABASE (Transact-SQL) is introduced in SQL Server 2014 Service Pack 2
78108383173767 Improves the performance for databases that have large number of partitions in SQL Server 2014 SP2
75795033173157 Adds a stored procedure for the manual cleanup of the change tracking side table in SQL Server 2014 SP2
39130043172998FIX: A severe error occurs when you use the sys.dm_db_uncontained_entities DMV in SQL Server 2014
69880683173156 Update adds AlwaysOn extended events and performance counters in SQL Server 2014
21971533172997 Update to add memory grant warning to the Showplan XML in SQL Server 2014 SP2
42976003170123 Supports DROP TABLE DDL for articles that are included in transactional replication in SQL Server 2014
67236093170116 FIX: Memory grant that's required to run optimized nested loop join isn't reflected in Showplan XML in SQL Server 2014
61703243170115 Information about enabled trace flags is added to the showplan XML in SQL Server 2014 SP2
59904253170114 Update to add DMF sys.dm_db_incremental_stats_properties in SQL Server 2014
6685025, 35122773170113 Update to expose per-operator query execution statistics in showplan XML and Extended Event in SQL Server 2014 SP2
61703173170112Update to expose maximum memory enabled for a single query in Showplan XML in SQL Server 2014
68529463170044 FIX: Illegal name character error when you parse module_end event output in SQL Server 2014
69273423170043 Poor performance when query contains anti-join on a complex predicate in SQL Server 2014 SP1
67278763170042 DMV sys.dm_db_index_operational_stats returns incorrect range_scan_count value in SQL Server 2014
69367843170022 Update lets SQL Server 2014 use all the user-mode virtual address space for a process
69450273170020 Informational messages added for tempdb configuration in the SQL Server error log in SQL Server 2014 SP2
69449853170019 Update to add info about SQL Server startup account to security policy in SQL Server 2014 error log
76386133170015 DMV sys.dm_os_memory_nodes returns a non-zero value for the pages_kb value for the DAC node in SQL Server 2014
66513483156304 Improvement for SQL Server AlwaysOn Lease Timeout supportability in SQL Server 2012 and 2014
70035723154421 FIX: Filestream directory is not visible after an AlwaysOn replica is restarted in SQL Server 2012 or 2014
67158153136780 UTF-8 encoding support for the BCP utility and BULK INSERT Transact-SQL command in SQL Server 2014 SP2
6589061, 6589062, 6589063,
6589064
3112363 Improvements for SQL Server AlwaysOn Lease Timeout supportability in SQL Server 2012 and 2014
65889833112362 FIX: You don’t receive any information about the replica when it is not visible in the availability group in SQL Server
65889823112361FIX: The alwayson_ddl_executed extended event doesn't include the error number in SQL Server 2012 or 2014
65889813107401New query memory grant options are available (min_grant_percent and max_grant_percent) in SQL Server 2012
65890603107400 Improved tempdb spill diagnostics in Showplan XML schema in SQL Server 2012 and 2014
65889993107399 Spatial performance improvements in SQL Server 2012 and 2014
65889953107398 Improved memory grant diagnostics when you use DMV in SQL Server 2012 and 2014
65890113107397 Improved diagnostics for query execution plans that involve residual predicate pushdown in SQL Server 2012 and 2014
65890073107172 Improve tempdb spill diagnostics by using Extended Events in SQL Server 2012 and 2014
65895873065060FIX: "Unable to create restore plan due to break in the LSN chain" error when you restore differential backup in SSMS
10463132925865Error when you execute SSIS package on FIPS-enabled Windows

Additional resolutions

Resolutions to the following issues are also included in SQL Server 2014 SP2.

VSTS bug numberDescription
6650726Unable to rename column in table even though CDC is no longer enabled.
6810365Print the table name and PK value of the row for 20598 error in msdistribution_history
6810368Print the Cmd that caused querytimeout errors without the need for verbose logging
6821167Provide easy way to print "change_tracking_hardened_cleanup_version" and "safe_cleanup_version" for procedure "sys.sp_flush_commit_table_on_demand"
6925734Rebuild Index on 2012/2014 removes corresponding usage stats in sys.dm_db_index_usage_stats (regression from 2008 R2)
6943695Log reader Asserts and dumps when destination table is an empty string
3988550Presence of batch sort / optimized nested loop operators result in extreme memory grants - causes server stability & performance issues
3781287Query_hash defined as UNIT64, doesn't match XEvent query_hash and query_hash from sys.dm_exec_query_stats defined as varbinary
7168415The user does not have ALTER TRACE permission could not run DELETE command on table with filters in merge replication
7343398Error executing business rule when the field name is too long
6167933Provide a method to find out the TLS/SSL protocol used by the client connection
6588970Dutch FTS using forms OfInflectional not working as expected
6588974Load logic for msxmlsql.dll leads to spurious "Failed to verify Authenticode signature" message
2128386SqlCmd quits without error with combination of embedded comments and curly braces ( 2 votes )
2288369Creating non-clustered index causes DBCC CheckDB With Extended_Logical_Checks to raise corruption error
5052858YYYY/MM/DD format for DATE not handled in BCP (unlike legacy Datetime)
5783955NULL values are ignored after altering a column from text to varchar(max)
6589326EKM DEK failing to initialize for keys with thumbprint less than maximum size
6616118Access violation when updating incremental statistics after removing partitions CPartitionFn::CPartitionFn
6589000set statistics io on' does not show sort's worktable statistics

Select the correct file to download and install

The SQL Server 2014 SP2 download page contains the system requirements for installing SQL Server 2014 SP2 and basic installation instructions. For additional documentation about how to upgrade installed 2014 SP2 components with a SQL Server 2014 servicing update, see Install SQL Server 2014 Servicing Updates.

Use the following table to identify the location and name of the file to download based on your currently installed version. The download pages provide system requirements and basic installation instructions.

Version you currently have installedAction you want to takeFile to download and install
A 32-bit version of any edition of SQL Server 2014Upgrade to the 32-bit version of SQL Server 2014 SP2SQLServer2014SP2-KB3171021-x86-ENU.exe from here
A 32-bit version of SQL Server 2014 RTM or SP1 ExpressUpgrade to the 32-bit version of SQL Server 2014 Express SP2 SQLServer2014SP2-KB3171021-x86-ENU.exe from here
A 32-bit version of only the client and manageability tools for SQL Server 2014 (including SQL Server 2014 Management Studio)Upgrade the client and manageability tools to the 32-bit version of SQL Server 2014 SP2SQLManagementStudio_x86_ENU.exe from here
A 32-bit version of SQL Server 2014 Management Studio Express Upgrade to the 32-bit version of SQL Server 2014 SP2 Management Studio ExpressSQLManagementStudio_x86_ENU.exe from here
A 32-bit version of any edition of SQL Server 2014 and a 32-bit version of the client and manageability tools (including SQL Server 2014 RTM Management Studio)Upgrade all products to the 32-bit version of SQL Server 2014 SP2SQLServer2014SP2-KB3171021-x86-ENU.exe from here
A 32-bit version of one or more tools from the Microsoft SQL Server 2014 RTM Feature Pack or the Microsoft SQL Server 2014 SP1 Feature PackUpgrade the tools to the 32-bit version of Microsoft SQL Server 2014 SP2 Feature PackOne or more files from Microsoft SQL Server 2014 SP2 Feature Pack
No 32-bit installation of SQL Server 2014 Management StudioInstall 32-bit SQL Server 2014 Management Studio including SP2SQLManagementStudio_x86_ENU.exe from here
No 32-bit version of SQL Server 2014 ExpressInstall 32-bit SQL Server 2014 Express including SP2SQLEXPR32_x86_ENU.exe from here
A 64-bit version of any edition of SQL Server 2014Upgrade to the 64-bit version of SQL Server 2014 SP2SQLServer2014SP2-KB3171021-x64-ENU.exe from here
A 64-bit version of SQL Server 2014 RTM or SP1 ExpressUpgrade to the 64-bit version of SQL Server 2014 SP2 SQLServer2014SP2-KB3171021-x64-ENU.exe from here
A 64-bit version of only the client and manageability tools for SQL Server 2014 (including SQL Server 2014 Management Studio)Upgrade the client and manageability tools to the 64-bit version of SQL Server 2014 SP2SQLManagementStudio_x64_ENU.exe from here
A 64-bit version of SQL Server 2014 Management Studio ExpressUpgrade to the 64-bit version of SQL Server 2014 SP2 Management Studio ExpressSQLManagementStudio_x64_ENU.exe from here
A 64-bit version of any edition of SQL Server 2014 and a 64-bit version of the client and manageability tools (including SQL Server 2014 RTM Management Studio)Upgrade all products to the 64-bit version of SQL Server 2014 SP2SQLServer2014SP2-KB3171021-x64-ENU.exe from here
A 64-bit version of one or more tools from the Microsoft SQL Server 2014 RTM Feature Pack or the Microsoft SQL Server 2014 SP1 Feature PackUpgrade the tools to the 64-bit version of Microsoft SQL Server 2014 SP2 Feature PackOne or more files from Microsoft SQL Server 2014 SP2 Feature Pack
No 64-bit installation of SQL Server 2014 Management StudioInstall 64-bit SQL Server 2014 Management Studio including SP2SQLManagementStudio_x64_ENU.exe from here
No 64-bit version of SQL Server 2014 ExpressInstall 64-bit SQL Server 2014 Express including SP2SQLEXPR_x64_ENU.exe from here


For more information about how to upgrade your SQL Server installation to SQL Server 2014 SP2, see Supported Version and Edition Upgrades.

Copyright attributions

  • This product contains software derived from the Xerox Secure Hash Function.
  • This product includes software from the zlib general purpose compression library.
  • Parts of this software are based in part on the work of RSA Data Security, Inc. Because Microsoft has included the RSA Data Security, Inc., software in this product, Microsoft is required to include the text below that accompanied such software:

    • Copyright 1990, RSA Data Security, Inc. All rights reserved.
    • License to copy and use this software is granted provided that it is identified as the "RSA Data Security, Inc., MD5 Message-Digest Algorithm" in all material mentioning or referencing this software or this function. License is also granted to make and use derivative works provided that such works are identified as "derived from the RSA Data Security, Inc., MD5 Message-Digest Algorithm" in all material mentioning or referencing the derived work.
    • RSA Data Security, Inc., makes no representations concerning either the merchantability of this software or the suitability of this software for any particular purpose. It is provided "as is" without express or implied warranty of any kind.
    These notices must be retained in any copies of any part of this documentation or software.
  • The Reporting Services mapping feature uses data from TIGER/Line Shapefiles that are provided courtesy of the United States Census Bureau(http://www.census.gov/). TIGER/Line Shapefiles are an extract of selected geographic and cartographic information from the Census MAF/TIGER database. TIGER/Line Shapefiles are available without charge from the United States Census Bureau. To get more information about the TIGER/Line shapefiles, go to http://www.census.gov/geo/www/tiger. The boundary information in the TIGER/Line Shapefiles is for statistical data collection and tabulation purposes only; its depiction and designation for statistical purposes does not constitute a determination of jurisdictional authority, rights of ownership, or entitlement, and does not reflect legal land descriptions. Census TIGER and TIGER/Line are registered trademarks of the United States Census Bureau.
Copyright 2012 Microsoft. All rights reserved.
References
For more information about how to determine the current SQL Server version and edition, select the following article number to go to the article in the Microsoft Knowledge Base:
321185 How to identify your SQL Server version and edition
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
Properties

Article ID: 3171021 - Last Review: 12/02/2016 13:32:00 - Revision: 8.0

Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web, SQL Server 2014 Reporting Services

  • kbfix kbsurveynew kbexpertiseadvanced atdownload KB3171021
Feedback