Cumulative update 2 for SQL Server 2014 SP1

This article describes cumulative update package 2 (Build number: 12.0.4422.0) for Microsoft SQL Server 2014 Service Pack 1 (SP1). This update contains hotfixes for issues that were fixed after the release of SQL Server 2014 SP1.

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
48141783088041FIX: 401 error occurs when you try to connect to an MDS solution by using MDS Add-in for Excel MDS
5181962 3074535FIX: 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
5181906972759FIX: Installing SQL Server 2008 Service Pack 1 may reset the "max_worker_threads" column value for a SQL Server Agent subsystem Management Tools
4812206 3082885FIX: Cannot find file error occurs when you execute a maintenance plan to back up database in SQL Server 2014 SQL service
51819683075176FIX: Incorrect results from the CHANGETABLE() function when snapshot isolation is enabled for a SQL Server 2012 or 2014 database SQL service
51819592820068Can't install SQL Server by using InstallShield or bootstrapping application Setup & Install
51819573069320FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 or 2014 Master Data Services to start the workflow Data Quality Services (DQS)
51819243074922FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 or SQL Server 2014 SQL performance
51819163074425FIX: CMEMTHREAD waits occur when you execute many ad hoc queries in SQL Server 2012 or SQL Server 2014 SQL service
51819143069154FIX: You cannot set a SQL Server 2012 or 2014 database to single-user mode if the database is read-only SQL service
51819083076444FIX: 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
47729213036330FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 Management Tools
51819523068703FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 or 2014 SQL service
51968103083187FIX: "Requested value was not found" error when you deploy a SQL Server 2014 database to Windows Azure Management Tools
50365053081758FIX: Can't view the properties of a contained database in Object Explorer in SQL Server 2014 SP1 Management Tools
49214663075850FIX: Error 1635 occurs when you use Product Update to install SQL Server 2014 SP1 and SQL Server 2014 SP1 CU1 Setup & Install
47760052987585Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012 SQL service
47453173047538FIX: Result of aggregated values is incorrect when you execute an MDX query in SSAS 2012 or SSAS 2014 Analysis Services
47452963033456FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012 Analysis Services
47370053016384FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014 Analysis Services
47369893010148FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS Analysis Services
47369883006838FIX: Instance of SSAS 2012 or SSAS 2014 crashes when cube writeback commit and processing transactions are executed at the same time Analysis Services
45845623029776FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension Analysis Services
51599523081291FIX: Increased HADR_SYNC_COMMIT wait types when AlwaysOn Availability Groups contain memory-optimized tables in SQL Server 2014 Service Pack 1 High Availability
50201413081074FIX: A stalled dispatcher system dump occurs forcing a failover and service outage on the availability groups in SQL Server 2014 Service Pack 1 High Availability
51819553068776FIX: 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
51819372965654FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer Reporting Services
51819303064292FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 or SQL Server 2014 SQL service
48671793071617FIX: "Cannot Start Application" error occurs when you start SQL Server Reporting Services Report Builder in SQL Server 2014 Service Pack 1 Reporting Services
47415773028216FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 or SSAS 2014 Analysis Services
47415353025408FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 or SSAS 2014 Analysis Services
47371143029126FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 or SSAS 2014 multidimensional cube Analysis Services
47370593017544FIX: SSAS 2012 or SSAS 2014 crashes when a writeback commit transaction and batch processing are executed concurrently Analysis Services
45845533042077FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012 or SSAS 2014 Analysis Services
45845173051798FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services Analysis Services
47441893054504FIX: The bcp utility may crash when you use SQL Server 2012 or SQL Server 2014 SQL connectivity
47676533057876FIX: An AlwaysOn database on a secondary replica shows a "NOT SYNCHRONIZING" status in SQL Server 2014 High Availability
49210393073294FIX: "Possible schema corruption. Run DBCC CHECKCATALOG" error occurs when you delete column in SQL Server 2014 SQL service
47753943067113FIX: Access violation and unexpected SQL Server shutdown occur when common criteria compliance is enabled SQL service
49990453075939FIX: An Access Violation occurs when a query uses ISNUMERIC functions in Join conditions in SQL Server 2014 Service Pack 1 SQL performance
51818983030352FIX: 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
51819003051243FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications SQL service
51819023069155FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012 SQL service
51819333064454FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 or SQL Server 2014 SQL performance
48379703077726FIX: An online rebuild of indexes is unsuccessful when a table partition is read-only in SQL Server 2014 Service Pack 1 SQL service
47415443027214FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014 Management Tools
50674653082513FIX: TDE certificate creation fails in SQL Server 2014 SP1 if the serial number is greater than 16 bytes SQL security

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
x64-based versions
Propriétés

ID d'article : 3075950 - Dernière mise à jour : 24 août 2015 - Révision : 1

Commentaires