Cumulative Update 10 for SQL Server 2014

S'aplica a: SQL Server 2014 Business IntelligenceSQL Server 2014 Business IntelligenceSQL Server 2014 Developer

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

How to get 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
51818923052461FIX: All attributes in element are ignored when you transform XML file in SSIS 2012 or SSIS 2014 Integration Services
51819213068359FIX: "Cannot find the OLAP cube Model" error when you update the pivot table in a SharePoint document in SQL Server 2012 or SQL Server 2014 Analysis Services
57150703095156FIX: Error 9002 and error 3052 when you try to add or back up log file in SQL Server 2012 or SQL Server 2014 High Availability
57150793087114FIX: PowerPivot for SharePoint doesn't run automatic data refresh on the first day of each month Analysis Services
57150813088307FIX: Scheduler deadlock on primary replica when you remove a replica from an AlwaysOn availability group in SQL Server 2012 or SQL Server 2014 High Availability
57150853077273FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012 or SQL Server 2014 SQL service
57151093088480FIX: Sort operator spills to tempdb in SQL Server 2012 or SQL Server 2014 when estimated number of rows and row size are correct SQL performance
57151113080856FIX: Information disclosure when you create a session cube by using dynamic role-based security in SQL Server 2012 or SQL Server 2014 Analysis Services
57151223089687FIX: Can't export empty Tablix header in CSV file when NoHeader is false in SSRS 2012 or SSRS 2014 Reporting Services
57151303087872FIX: Access violations when you use the FileTable feature in SQL Server 2012 or SQL Server 2014 SQL service
55864783074434FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory SQL service
48428203070382FIX: Server crash occurs when you run a remote query in a stored procedure by using an invalid user in SQL Server 2014 SQL service
50365243081757FIX: Error occurs when you try to view the property of the contained database in SQL Server 2014 Management Tools
56188093092704Improvements for Distribution Agent telemetry for Azure Subscriber are available in SQL Server 2014 SQL service
57500043097073FIX: CPU usage is higher than expected when you reduce the value of CAP_CPU_PERCENT argument in creating resource pool SQL service
57079613097601FIX: Access violation when you query against a table that contains column store indexes in SQL Server 2014 SQL service
55061823098529FIX: Assert occurs when you change the type of column in a table that has clustered columnstore index in SQL Server 2014 SQL service
51819253063438FIX: Both XSD validation and XSLT transformation fail when you run an SSIS 2014 package that contains multiple concurrent XML tasks Integration Services
51819403066299FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English Master Data Services (MDS)
51819483075669FIX: SSAS 2012 or SSAS 2014 crashes when you execute an MDX query that contains lots of Union expressions Analysis Services
51819603073530FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012 or SQL Server 2014 Analysis Services
51819643073907FIX: SSIS 2012 or SSIS 2014 package with an Execute SQL Task may stop responding Analysis Services
57150883080209FIX: Error 602 when you run a stored procedure repeatedly in SQL Server 2012 or SQL Server 2014 SQL performance
57150933090049FIX: Transparent Data Encryption certificate can't be created in SQL Server 2012 or SQL Server 2014 SQL security
57150963081580FIX: "String or binary data would be truncated" error when you use peer-to-peer replication in SQL Server 2012 or SQL Server 2014 SQL service
57151063087094FIX: It takes longer than expected when you run a query with non-admin user role in SSAS 2012 or SSAS 2014 in Tabular model Analysis Services
57375332682488FIX: Backup operation fails in a SQL Server database after you enable change tracking SQL service
57151013091643FIX: Error occurs when you configure SQL Server replication or set up a linked server in SQL Server 2012 or SQL Server 2014 SQL security
50365243081758FIX: Can't view the properties of a contained database in Object Explorer in SQL Server 2014 SP1 SQL service
50382623092702FIX: It takes a longer time than earlier versions of SQL Server when you run DBCC CHECKDB in SQL Server 2012 SQL service
5285700321185This update introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:
Additionally, this update also adds the CU number information to the first line of the SQL Server error log.
For more information, review Methods 2 through Method 4 under the section How to determine which version and edition of SQL Server Database Engine is running in How to determine the version and edition of SQL Server and its components.

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 don't have to make any changes to the registry.