Cumulative update 9 for SQL Server 2014

This article describes cumulative update package 9 (Build number: 12.0.2553.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
45408123057876FIX: An AlwaysOn database on a secondary replica shows a "NOT SYNCHRONIZING" status in SQL Server 2014 High Availability
49210713073294FIX: "Possible schema corruption. Run DBCC CHECKCATALOG" error occurs when you delete column in SQL Server 2014 SQL service
47441883054504FIX: The bcp utility may crash when you use SQL Server 2012 or SQL Server 2014 SQL connectivity
45441043074434FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory SQL service
51818973030352FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database SQL service
51818993051243FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications SQL service
51819013069155FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012 SQL service
51819293064292FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 or SQL Server 2014 SQL service
51819313064454FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 or SQL Server 2014 SQL performance
51819362965654FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer Reporting Services
51819543068776FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012 or 2014 SQL performance
41575663038876FIX: It takes longer time than expected to list the databases in Object Explorer in SSMS 2014 Management Tools
51867323082005FIX: Case-sensitive does not work in MDS database in SQL Server 2014 Master Data Services (MDS)
50054353082860FIX: Access violation occurs when you execute a query that contains many joins and coalesce functions in SQL Server 2014 SQL performance
48122063082885FIX: Cannot find file error occurs when you execute a maintenance plan to back up database in SQL Server 2014 Management Tools
48432783080155FIX: Rare index corruption when you build a columnstore index with parallelism on a partitioned table in SQL Server 2014 SQL service
50201803081020FIX: A stalled dispatcher system dump occurs resulting in failover and service outage on the availability groups in SQL Server 2014 High Availability
47453123054180FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2014 SP1 SQL service
51819073076444FIX: Cannot enable "change data capture" on a table that uses a unique index with more than one included column in SQL Server 2012 or 2014 SQL service
51819133069154FIX: You cannot set a SQL Server 2012 or 2014 database to single-user mode if the database is read-only SQL service
51819153074425FIX: CMEMTHREAD waits occur when you execute many ad hoc queries in SQL Server 2012 or SQL Server 2014 SQL service
51819233074922FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 or SQL Server 2014 SQL performance
51819563069320FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 or 2014 Master Data Services to start the workflow MDS
51819582820068Can't install SQL Server by using InstallShield or bootstrapping application Setup & Install
51819623074535FIX: The Resource database is missing after you install updates or service packs for instances of SQL Server 2012 one after another and then restart the server SQL service
48119303072814FIX: Access violation occurs when you connect to an instance of SQL Server by using sqlcmd utility in SQL Server 2014 SQL connectivity
51819503068703FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 or 2014 SQL service
51819673075176FIX: Incorrect results from the CHANGETABLE() function when snapshot isolation is enabled for a SQL Server 2012 or 2014 database SQL service
51968153083189FIX: "Requested value was not found" error when you deploy a SQL Server 2014 database to Windows Azure Management Tools
51819173061215FIX: "Cannot read 8 bytes from file" error occurs when you use SSIS 2012 or 2014 Integration Services

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 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.
Cumulative update package file information
Properties

Article ID: 3075949 - Last Review: 17 Aug 2015 - Revision: 1

Feedback