KB3094220 - Cumulative Update 10 for SQL Server 2014

Applies to: SQL Server 2014 Business IntelligenceSQL Server 2014 DeveloperSQL Server 2014 Enterprise

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 number KB article number Description Fix area
5181892 3052461 FIX: All attributes in element are ignored when you transform XML file in SSIS 2012 or SSIS 2014 Integration Services
5181921 3068359 FIX: "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
5715070 3095156 FIX: 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
5715079 3087114 FIX: PowerPivot for SharePoint doesn't run automatic data refresh on the first day of each month Analysis Services
5715081 3088307 FIX: 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
5715085 3077273 FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012 or SQL Server 2014 SQL service
5715109 3088480 FIX: 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
5715111 3080856 FIX: Information disclosure when you create a session cube by using dynamic role-based security in SQL Server 2012 or SQL Server 2014 Analysis Services
5715122 3089687 FIX: Can't export empty Tablix header in CSV file when NoHeader is false in SSRS 2012 or SSRS 2014 Reporting Services
5715130 3087872 FIX: Access violations when you use the FileTable feature in SQL Server 2012 or SQL Server 2014 SQL service
5586478 3074434 FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory SQL service
4842820 3070382 FIX: Server crash occurs when you run a remote query in a stored procedure by using an invalid user in SQL Server 2014 SQL service
5036524 3081757 FIX: Error occurs when you try to view the property of the contained database in SQL Server 2014 Management Tools
5618809 3092704 Improvements for Distribution Agent telemetry for Azure Subscriber are available in SQL Server 2014 SQL service
5750004 3097073 FIX: CPU usage is higher than expected when you reduce the value of CAP_CPU_PERCENT argument in creating resource pool SQL service
5707961 3097601 FIX: Access violation when you query against a table that contains column store indexes in SQL Server 2014 SQL service
5506182 3098529 FIX: Assert occurs when you change the type of column in a table that has clustered columnstore index in SQL Server 2014 SQL service
5181925 3063438 FIX: Both XSD validation and XSLT transformation fail when you run an SSIS 2014 package that contains multiple concurrent XML tasks Integration Services
5181940 3066299 FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English Master Data Services (MDS)
5181948 3075669 FIX: SSAS 2012 or SSAS 2014 crashes when you execute an MDX query that contains lots of Union expressions Analysis Services
5181960 3073530 FIX: 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
5181964 3073907 FIX: SSIS 2012 or SSIS 2014 package with an Execute SQL Task may stop responding Analysis Services
5715088 3080209 FIX: Error 602 when you run a stored procedure repeatedly in SQL Server 2012 or SQL Server 2014 SQL performance
5715093 3090049 FIX: Transparent Data Encryption certificate can't be created in SQL Server 2012 or SQL Server 2014 SQL security
5715096 3081580 FIX: "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
5715106 3087094 FIX: 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
5737533 2682488 FIX: Backup operation fails in a SQL Server database after you enable change tracking SQL service
5715101 3091643 FIX: Error occurs when you configure SQL Server replication or set up a linked server in SQL Server 2012 or SQL Server 2014 SQL security
5036524 3081758 FIX: Can't view the properties of a contained database in Object Explorer in SQL Server 2014 SP1 SQL service
5038262 3092702 FIX: It takes a longer time than earlier versions of SQL Server when you run DBCC CHECKDB in SQL Server 2012 SQL service
5285700 321185 This 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:
SELECT @@VERSIONSELECT SERVERPROPERTY('PRODUCTUPDATELEVEL')
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


Prerequisites

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.