Cumulative update 6 for SQL Server 2014 SP1

Applies to: SQL Server 2014 Business IntelligenceSQL Server 2014 Business IntelligenceSQL Server 2014 Developer
This article describes cumulative update package 6 (Build number: 12.0.4457.0) for Microsoft SQL Server 2014 Service Pack 1 (SP1). This update contains fixes that were released after the release of SQL Server 2014 SP1.

Cumulative update

Cumulative updates are now available at the Microsoft Download Center.

Only the most recent cumulative update that was released for SQL Server 2014 SP1 is available at the Download Center.

  • Each new cumulative update (CU) contains all the fixes that were included with the previous CU for the installed version/Service Pack of SQL Server.
  • Microsoft recommends ongoing, proactive installation of CUs as they become available:

    • SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.
    • Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.
    • CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.

  • Just as for SQL Server service packs, we recommend that you test CUs before you deploy them to production environments.
  • We recommend that you upgrade your SQL Server installation to the latest SQL Server 2014 service pack .

How to obtain this cumulative update package

The following update is available from the Microsoft Download Center:

Download the latest cumulative update package for Microsoft SQL Server 2014 Service Pack 1 (SP1) now.

If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

The Microsoft SQL Server 2014 Integration Services Attunity Oracle CDC Designer/Service Feature Pack is a stand-alone package which provide additional value for SQL Server Integration Services (SSIS).

Download Download the Microsoft SQL Server 2014 Integration Services Attunity Oracle CDC Designer/Service Feature Pack package now.


Note After future Cumulative Updates are released for SQL Server 2014 Service Pack 1, this CU can be located and downloaded from the Microsoft Windows Update Catalog. However, Microsoft recommends that you install the latest cumulative update available.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
71738783150152FIX: Estimated number of rows is calculated incorrectly for a predicate involving a unique GUID column in SQL Server 2014 SQL service
71036753115741FIX: "The process cannot access the file" error when an XML task fails in SQL Server Integration Services
68090353138455FIX: "Non-yielding Scheduler" error when versioning cleanup task runs on a SQL Server 2014 AlwaysOn secondary replica SQL service
68301583120595FIX: Column data may be deleted when you update another variable-length column in a table of a database upgraded from SQL Server 2005 SQL service
68301653109051FIX: Default settings are used when you print to a non-default printer in SQL Server 2012 or SQL Server 2014 Reporting Services Reporting Services
68302053100451FIX: "Invalid cursor position" error when you retrieve spatial data by using SQLSetPos in SQL Server 2014 or SQL Server 2012 SQL service
68305493135749FIX: Incorrect group members are obtained when you run the xp_logininfo stored procedure in SQL Server SQL security
68305553123309FIX: The Log Reader Agent stops intermittently and an Access Violation occurs in SQL Server 2012 or SQL Server 2014 SQL service
68305573125525FIX: The CHANGETABLE function in a query returns incorrect results if change tracking is enabled for a SQL Server database SQL service
69917463137779FIX: Assertion failure on secondary replica when you use AlwaysOn Availability Groups in SQL Server 2014 SQL service
69917483125459FIX: Can't deploy SSRS solution by using command line in SQL Server 2014 Reporting Services
68301453123485FIX: Slow performance when you run MDX query in SSAS 2012 or SSAS 2014 Analysis Services
67199563147825FIX: Assertion failures when you use the distributed transaction feature with AlwaysOn availability groups in SQL Server 2014 SQL service
68301763132058FIX: Error occurs when you try to drop or delete filegroups or partition schemes and functions in SQL Server SQL service
70562543151176FIX: Number of rows is underestimated for a query predicate that involves a scalar user-defined function in SQL Server 2014 SQL performance
72463813151526FIX: Incremental deployment of an Analysis Services project to SQL Server 2014 Service Pack 1 causes unexpected shutdown Analysis Services
71945863152135FIX: An access violation occurs when you run a spatial query that contains OPENQUERY methods through a linked server in SQL Server 2014 SQL performance
65447623152377FIX: Error 5120 when you create or use a FILESTREAM-enabled database on a dynamic disk in an instance of SQL Server 2014 SQL service
72495833131443FIX: "Cannot resolve the collation conflict" error when you apply a snapshot to the subscriber database in SQL Server SQL service
47367403034297FIX: Cannot close the connections made by sqlagent.exe when SQL Server and SQL Server Agent run for several days Management Tools
72496383138930FIX: Access violation when you execute a stored procedure that uses a cursor on a table variable in SQL Server SQL service
72496403138659FIX: Slow performance when you query numeric data types from an Oracle database SQL service
72495883136789FIX: Access violation when you run an XMLA command in SQL Server Analysis Services 2012 Analysis Services
70303613146404FIX: Canceling a backup task crashes SQL Server 2014
70666243147012FIX: Large disk checkpoint usage occurs for an In-Memory optimized filegroup during heavy non-In-Memory workloads In-Memory OLTP
60318613156157Running multiple UPDATE STATISTICS for different statistics on a single table concurrently is available SQL performance
68301843132062FIX: SMK initialization fails on one node of a SQL Server 2012 or SQL Server 2014 failover cluster SQL security
68302033135750FIX: SQL Server may crash when a request for execution of a remote stored procedure contains incomplete definition of arguments SQL service
69917453135751FIX: Columnstore index corruption occurs when you use AlwaysOn Availability Groups in SQL Server 2014 SQL service
69884953147297FIX: STDEVX.P returns an incorrect result when you calculate the standard deviation in SQL Server 2014 Analysis Services
69179013147826FIX: The upgrade of an instance of SQL Server to Cumulative Update 1 for SQL Server 2014 Service Pack 1 fails when you use a slipstream installation Setup & Install
68301883123089FIX: The INSTEAD OF trigger uses a different collation than the contained database uses in SQL Server 2012 or SQL Server 2014 SQL performance
69754943148563FIX: The back up of a SSAS database fails with a memory allocation error in SQL Server 2014 Analysis Services
68045543150896FIX: A "Non-yielding Scheduler" condition occurs when you perform a BULK INSERT and the data file exists in a FileTable in SQL Server 2014 SQL service
72496483142595FIX: An access violation occurs when a database table name contains Japanese characters SQL service
68857733152378FIX: FileTables in an AlwaysOn availability group become unavailable after failover in an instance of SQL Server 2014 SQL service
72437023152390FIX: Memory corruption causes an access violation in an instance of SQL Server 2014 SQL service
72171073152606FIX: SELECT…INTO statement retrieves incorrect result from a clustered columnstore index in SQL Server 2014 SQL service
72496063136205FIX: "Failed to create a new table" error when you export the cleansing results of a Data Quality Services domain in SQL Server 2012 or SQL Server 2014 Data Quality Services (DQS)
72496173139489FIX: "A severe error occurred on the current command" when a Table-Valued User-Defined function is referred to by a synonym SQL service
72496423139911Access violation when you perform a cell writeback that invokes the LookupCube MDX function Analysis Services
69889663155236FIX: An access violation occurs when you process a partition with the Process Add mode in a SSAS 2014 Tabular instance Analysis Services
77018023167394FIX: Unexpected blocking or deadlocks after you install deprecated Cumulative Update 6 for SQL Server 2014 SP1 SQL service

Notes for this update

Hybrid environments deployment

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

Cumulative update package information

Prerequisites

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

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.

References