Cumulative update package 3 for SQL Server 2014

Applies to: SQL Server 2014 EnterpriseSQL Server 2014 EnterpriseSQL Server 2014 Developer

This article describes cumulative update package 3 (Build number: 12.0.2402.0) for Microsoft SQL Server 2014. This update contains hotfixes for issues that were fixed after the release of SQL Server 2014.

How to obtain this cumulative update package

Click "Hotfix Download Available" at the top of this Knowledge Base article. If the "Hotfix Request" page doesn't appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
25565942936984 FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL ServerSQL service
27144972952444 FIX: Poor performance when you use table variables in SQL Server 2012 or SQL Server 2014SQL performance
25782782954861 FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDTIntegration Services
25782822957768 FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012 or SSRS 2014Reporting Services
25782762957957 FIX: Attributes sort incorrectly after you use the Attribute Properties function in SQL Server MDS Add-in for ExcelData Quality Services (DQS)
25782882959342 FIX: Data-driven subscription can't be created when the driving query takes longer than 30 seconds to execute in SQL ServerReporting Services
23191342960924 FIX: Cannot open the memory-optimized table template remotely in SQL Server 2014Management Tools
25783022961559 FIX: Incorrect folder when deploying SQL Server 2012 or SQL Server 2014 PowerPivot solutions by using SharePoint 2013 Central AdminAnalysis Services
25783042963372 FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012 or SSAS 2014Analysis Services
28230962963386 FIX: SSRS 2012 or SSRS 2014 fails with IsolatedStorageException when subscriptions exported to Excel worksheets are larger than 10 MBReporting Services
27827482963668 FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitionsSQL service
25782852963836 FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012 or SSRS 2014Reporting Services
25252922967635 FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDS or SQL Server 2014 MDSDQS
25043882968418 FIX: "Non-yielding scheduler" error when you insert or update many rows in one transaction in SQL Server 2014In-Memory OLTP
29061092968909 FIX: Access violation when you query sys.extended_properties table in SQL Server 2012 or SQL Server 2014SQL service
29061132973561 FIX: Error when you insert a record into a FileTable or FILESTREAM in SQL Server 2012 or SQL Server 2014SQL service
29060952975322 FIX: Blank value is set to NULL value in a business rule in MDS of SQL Server 2012 or SQL Server 2014DQS
29061392975402 FIX: Log Reader Agent crashes during initialization when you use transactional replication in SQL ServerSQL service
25156532975434 FIX: Error when you complete an SSAS 2014 image after specifying a non-default root directory Analysis Services
27827572977312 FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL ServerSQL service
29068932978472 FIX: UPDATE or INSERT statement on CCI makes sys.partitions not match actual row count in SQL Server 2014SQL service
29061372979121 FIX: Log Reader Agent fails when you upgrade from SQL Server 2008 to SQL Server 2012 or SQL Server 2014SQL service
29061412979587 FIX: Image completion setup fails when you use SysPrep to install localized version of SQL ServerSetup & Install
27898722981764 FIX: Cannot create indexed view on a clustered columnstore index and BCP on the table fails in SQL Server 2014 SQL service
27969992984628 FIX: Auto-statistics creation increases the compilation time for natively compiled stored procedure in SQL Server 2014 In-Memory OLTP
27971302984629 FIX: LCK_M_SCH_M occurs when you access memory-optimized table variables outside natively compiled stored proceduresIn-Memory OLTP
25312712984907 FIX: "The current SQL Server edition is not supported by MDS" error when you browse to the MDS websiteDQS
27045512986081 FIX: An access violation occurs when you use UPDATE STATISTICS on a computed column in SQL Server 2014SQL performance
28280092988552 Update enables SQLDOM to support "service_objective" in the Microsoft Azure SQL Database SQL service
27188252989704 FIX: Some columns in sys.column_store_segments view show NULL value when the table has non-dbo schema in SQL Server 2014SQL service
28951692989715 FIX: Dimension attribute is lost in Excel PivotTable Field List when you set AttributeHierarchyDisplayFolder to "\" in SSDT-BIAnalysis Services

Notes for this update

Cumulative update

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • We recommend that you apply the most recent update release .
    • This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems.
    • The most recent update release contains all the hotfixes and all the updates that were included with the previous SQL Server 2014 update release.
  • We recommend that you upgrade your SQL Server to the next SQL Server 2014 service pack .

Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (Such as AlwaysOn, replication, cluster, mirroring, and cluster), we recommend that you go and refer to the following articles before you deploy them:

Cumulative update package information


To apply this cumulative update package, you must be running SQL Server 2014.

Restart information

You may have to restart the computer after you apply this cumulative update package.

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.