Cumulative update package 8 for SQL Server 2014

Applies to: SQL Server 2014 EnterpriseSQL Server 2014 EnterpriseSQL Server 2014 Standard

This article describes cumulative update package 8 (Build number: 12.0.2546.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 number KB article number Description Fix area
4778150 3067257 FIX: Partial results in a query of a clustered columnstore index in SQL Server 2014 SQL service
4745322 3051145 FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014 SQL service
4544422 3029096 FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly Integration Services
4638931 3058512 FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014 Integration Services
4719045 3064784 FIX: Access violation occurs when you query against a table that contains column store indexes in SQL Server 2014 SQL service
4745295 3033456 FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012 Analysis Services
4745316 3047538 FIX: Result of aggregated values is incorrect when you execute an MDX query in SSAS 2012 or SSAS 2014 Analysis Services
4520890 3067896 Incorrect results are returned in an indexed view after an Insert or Delete operation on the base table occurs in SQL Server 2014 SQL performance
4715603 3070139 FIX: Error 33294 occurs when you alter column types on a table that has clustered columnstore indexes in SQL Server 2014 SQL service
4516100 3069488 "Non-yielding Scheduler" error occurs and SQL Server stops responding when a database has columnstore indexes on a Microsoft SQL Server 2014 instance SQL service
4745318 3052404 FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012 SQL connectivity
4745324 3050636 FIX: Cannot schedule a subscription in an SSRS 2012 or SSRS 2014 report when the data source is SAP NetWeaver BI type Reporting Services
4745309 3045333 FIX: "C2 Audit mode" option cannot be enabled by using sp_configure and restarting SQL Server SQL security
4745305 3043889 FIX: The chart in SSRS 2012 or SSRS 2014 report is not updated correctly when you update the parameter in the URL of the report Reporting Services
4744173 3042629 FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012 or SQL Server 2014 SQL service
4336261 3036201 FIX: The notification email link is broken when a special character is part of the URL in SQL Server 2012 or SQL Server 2014 MDS Master Data Services(MDS)
4638932 2999809 FIX: Poor performance when a query contains table joins in SQL Server 2014 Management Tools
4838266 3070147 Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014 SQL service
4320465 3048734 FIX: An I/O error that occurs on BPE files causes SQL Server 2014 to disable BPE SQL service
4319316 3048627 FIX: "Cannot access the specified path or file on the server" when you use CSV in SSMS to back up or restore database Management Tools
4794520 3067968 FIX: Paging out in memory occurs when columnstore index query consumes large memory in SQL Server 2014 SQL service
4465182 972759 FIX: Installing SQL Server 2008 Service Pack 1 may reset the "max_worker_threads" column value for a SQL Server Agent subsystem Management Tools
4745307 3051993 FIX: The value of NUMBER type is truncated when you select data from an Oracle-linked server by using OLE DB provider SQL service
4488005 3066682 FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014 MDS
4745314 3020350 FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages Integration Services
4745709 3026954 FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 or SQL Server 2012 Integration Services
4745297 3035737 FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time Analysis Services
4729309 3052167 FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014 SQL performance
4632737 3061685 FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014 SQL performance
4729310 3063054 Update enables Premium Storage support for Data files on Azure Storage and resolves backup failures SQL service
4745330 3011867 SQL Server in-place upgrade fails if the there's no JOBS folder Setup & Install
4745711 2619077 FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry SQL service
4728820 3067659 FIX: Data loss might occur when you use Windows Azure Storage in SQL Server 2014 on high latency networks SQL service
4633760 3053752 FIX: PowerPivot Gallery displays Create Power View Report button incorrectly when you use SSAS 2014 as a data source Analysis Services
4507041 3055646 FIX: Error 35377 when you run a parallel query that contains MERGE statements in SQL Server 2014 SQL service

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.