This article describes cumulative update package 2 (Build number: 11.0.5548.0) for Microsoft SQL Server 2012 Service Pack 2 (SP2). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP2.
Click "Hotfix Download Available" at the top of this Knowledge Base article. If the "Hotfix Request" page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.
|VSTS bug number||KB article number||Description||Fix area|
|2921035||2924996||FIX: Issues when you export a report to PDF that has Unicode fonts in SQL Server 2008 R2 or SQL Server 2012||SQL service|
|2525248||2952260||FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL Server||SQL service|
|2985224||2958054||FIX: SQL Cache Memory decreases and CPU usage increases when you rebuild an index for a table in SQL Server||SQL service|
|2906079||2962767||FIX: "Cannot insert duplicate key" error occurs when you update a table by using a bitmap index that contains a partition key in SQL Server 2012||SQL performance|
|2906083||2963137||FIX: Incorrect result is returned when you query multiple dimension members in MDX and DAX in SSAS 2012||Analysis Services|
|2556602||2963408||FIX: Error 5180 occurs when you query BLOB column data in SQL Server||SQL service|
|2782747||2963668||FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions||SQL service|
|2906092||2965069||FIX: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012||SQL performance|
|2906102||2965654||FIX: SSRS 2012 report is cut horizontally after you apply Update MS13-088 on a computer||Reporting Services|
|2906098||2965758||FIX: Memory leak occurs when you start and stop an XEvent session repeatedly in SQL Server 2012||SQL service|
|2906100||2965922||FIX: Issue when you configure scheduled data refresh for the PowerPivot workbook in SharePoint 2013||BI Azure|
|2906088||2967103||FIX: Service broker stops working when you unregister and remove a session in SQL Server||SQL service|
|2782750||2967240||FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server||SQL service|
|2906106||2967594||FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL Server 2012||SQL service|
|2906108||2968909||FIX: Access violation when you query sys.extended_properties table in SQL Server 2012 or SQL Server 2014||SQL service|
|2906110||2968914||FIX: Undetected deadlock occurs when you use a sequence object in SQL Server 2012||SQL service|
|2906116||2970421||FIX: The database sticks in role configuration phase when you perform a manual failover of a mirrored database||High Availability|
|2906118||2972411||FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012||Reporting Services|
|2906096||2972463||FIX: Report cache is not cleaned up after the cache expiration when you use SSRS 2012 in SharePoint integrated mode||Reporting Services|
|2906120||2972996||FIX: Error when you execute a Transact-SQL query that contains a long case statement in SQL Server 2012||SQL service|
|2906112||2973561||FIX: Error when you insert a record into a FileTable or FILESTREAM in SQL Server 2012 or SQL Server 2014||SQL service|
|2906122||2973921||FIX: "allow mixed content" popup when you use PowerView that contains map data in SSRS 2012 on SharePoint website||Reporting Services|
|2906094||2975322||FIX: Blank value is set to NULL value in a business rule in MDS of SQL Server 2012 or SQL Server 2014||Data Quality Services (DQS)|
|2906090||2975385||FIX: User obtains incorrect data when two users in the same security role run the same client report in SSAS 2012||Analysis Services|
|2906125||2975498||FIX: Cannot view Power View sheet from SharePoint 2013 when a workbook uses certain Korean characters as file name||Reporting Services|
|2906114||2976953||FIX: The DAX query with filter returns incorrect result after you run a DAX query without any filters in SSAS 2012||Analysis Services|
|2906129||2976966||FIX: Cannot install the Windows Forms application that has ReportViewer control||Reporting Services|
|2906086||2977271||FIX: Performance improvement for SQL Server Spatial data access in SQL Server 2012||SQL service|
|2782756||2977312||FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL Server||SQL service|
|2906136||2979121||FIX: Log Reader Agent fails when you upgrade from SQL Server 2008 to SQL Server 2012 or SQL Server 2014||SQL service|
|2906134||2979304||FIX: Error when you run RBS Maintainer in SQL Server 2012||SQL service|
|2906132||2980395||FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server 2012||SQL performance|
|2821553||2984249||FIX: Null fields are returned when the dataset in SSRS retrieves a stored procedure with required parameters||Reporting Services|
|3038775||2986423||FIX: It takes a long time to add new columns to a table when the row size exceeds the maximum allowed size||SQL service|
|2890365||2986627||FIX: UPDATE STATISTICS performs incorrect sampling and processing for a table with columnstore index in SQL Server 2012||SQL performance|
|2794982||2987809||FIX: Report format is misaligned when you view the report that has certain report items in Internet Explorer 11||Reporting Services|
|2878593||2987812||FIX: No information about extensive lock conflicts in the SSAS msmdsrv.log file||Analysis Services|
|2878600||2988166||FIX: Additional semicolons are added to object definition when you run Invoke-Sqlcmd in SQL Server 2012||Management Tools|
|2718715||2989590||FIX: Except function does not return the calculated member that is created at the ALL member level in SSAS 2012||Analysis Services|
|2719620||2989704||FIX: Some columns in sys.column_store_segments view show NULL value when the table has non-dbo schema in SQL Server||SQL service|
|2933143||2989810||FIX: Error when you use bcp_init to do BCP and use local temp table as input parameter in SQL Server Native Client 11.0||SQL service|
|2887381||2991526||FIX: SSIS XML Source task fails to load the data from URI in SQL Server 2012||Integration Services|
|2808659||2991528||FIX: SSIS package execution fails when it uses DT_TEXT data type after you apply SQL Server 2012 SP2||Integration Services|
|2738813||2992069||FIX: XMLA and Windows PowerShell return different code for the same SSAS 2012 processing||Analysis Services|
|2895444||2992414||FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSIS 2012||Integration Services|
|2980111||2993262||FIX: Some rows are missing in the result when you run query to select data from Oracle linked server by using merge join||SQL performance|
|2949206||2993483||FIX: SSAS 2012 processing fails when you perform a Process Full operation on many partitions in a transaction||Analysis Services|
|3000520||2993529||FIX: Business rule validation fails with collation mismatch error in SQL Server 2012 MDS||DQS|
- 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 2012 update release.
- We recommend that you upgrade your SQL Server to the latest SQL Server 2012 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:
- SQL Server failover cluster rolling update and service pack process.
If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP:
- Install the service pack on the passive node.
- Install the service pack on the active node, and this step requests service restart.
- Upgrade and update of availability group servers that use minimal downtime and data loss.
If you enable AlwaysOn with SSISDB catalog for additional considerations about how to apply a CU or SP in these environments, go and see the article from the following MSDN blog:
- How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
- How to apply a hotfix for SQL Server in a replication topology
- How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
- Overview of SQL Server Servicing Installation
PrerequisitesTo apply this cumulative update package, you must be running SQL Server 2012 SP2.
Restart informationYou may have to restart the computer after you apply this cumulative update package.
Registry informationTo use one of the hotfixes in this package, you do not have to make any changes to the registry.
- How to obtain the latest service pack for SQL Server 2012.
- The Incremental Servicing Model for SQL Server to deliver hotfixes for reported problems.
- Naming schema for Microsoft SQL Server software update packages.
- Description of the standard terminology that is used to describe Microsoft software updates.
Article ID: 2983175 - Last Review: Jun 17, 2015 - Revision: 1
Microsoft SQL Server 2012 Service Pack 2, Microsoft SQL Server 2012 Analysis Services, Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Express, Microsoft SQL Server 2012 Business Intelligence, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2012 Web