Cumulative update package 8 for SQL Server 2014

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 numberKB article numberDescriptionFix area
45232433067826An "Access Violation" occurs when you connect to an instance of SQL Server 2014 SQL service
47781503067257FIX: Partial results in a query of a clustered columnstore index in SQL Server 2014 SQL service
47453223051145FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014 SQL service
45444223029096FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly Integration Services
46389313058512FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014 Integration Services
47190453064784FIX: Access violation occurs when you query against a table that contains column store indexes in SQL Server 2014 SQL service
47452953033456FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012 Analysis Services
47453163047538FIX: Result of aggregated values is incorrect when you execute an MDX query in SSAS 2012 or SSAS 2014 Analysis Services
45208903067896Incorrect results are returned in an indexed view after an Insert or Delete operation on the base table occurs in SQL Server 2014 SQL performance
47156033070139FIX: Error 33294 occurs when you alter column types on a table that has clustered columnstore indexes in SQL Server 2014 SQL service
45161003069488"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
47453183052404FIX: 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
47453243050636FIX: Cannot schedule a subscription in an SSRS 2012 or SSRS 2014 report when the data source is SAP NetWeaver BI type Reporting Services
47453093045333FIX: "C2 Audit mode" option cannot be enabled by using sp_configure and restarting SQL Server SQL security
47453053043889FIX: 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
47441733042629FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012 or SQL Server 2014 SQL service
43362613036201FIX: 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)
46389322999809FIX: Poor performance when a query contains table joins in SQL Server 2014 Management Tools
48382663070147Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014 SQL service
43204653048734FIX: An I/O error that occurs on BPE files causes SQL Server 2014 to disable BPE SQL service
43193163048627FIX: "Cannot access the specified path or file on the server" when you use CSV in SSMS to back up or restore database Management Tools
47945203067968FIX: Paging out in memory occurs when columnstore index query consumes large memory in SQL Server 2014 SQL service
4465182972759FIX: Installing SQL Server 2008 Service Pack 1 may reset the "max_worker_threads" column value for a SQL Server Agent subsystem Management Tools
47453073051993FIX: The value of NUMBER type is truncated when you select data from an Oracle-linked server by using OLE DB provider SQL service
44880053066682FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014 MDS
47453143020350FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages Integration Services
47457093026954FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 or SQL Server 2012 Integration Services
47452973035737FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time Analysis Services
47293093052167FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014 SQL performance
46327373061685FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014 SQL performance
47293103063054Update enables Premium Storage support for Data files on Azure Storage and resolves backup failures SQL service
47453303011867SQL Server in-place upgrade fails if the there's no JOBS folder Setup & Install
47457112619077FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry SQL service
47288203067659FIX: Data loss might occur when you use Windows Azure Storage in SQL Server 2014 on high latency networks SQL service
46337603053752FIX: PowerPivot Gallery displays Create Power View Report button incorrectly when you use SSAS 2014 as a data source Analysis Services
45070413055646FIX: 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:
Language support
Components updated
Support for this update
How to uninstall this update

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 do not have to make any changes to the registry.
Cumulative update package file information
คุณสมบัติ

รหัสบทความ: 3067836 - การตรวจสอบครั้งสุดท้าย: 22 ก.ค. 2015 - ฉบับแก้ไข: 1

คำติชม