Cumulative Update package 2 for SQL Server 2012 SP2

Applies to: SQL Server 2012 Analysis ServicesSQL Server 2012 DeveloperSQL Server 2012 Enterprise
Update Available
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.

How to obtain this cumulative update package

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.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
2921035 2924996 FIX: Issues when you export a report to PDF that has Unicode fonts in SQL Server 2008 R2 or SQL Server 2012SQL service
25252482952260 FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL ServerSQL service
29852242958054 FIX: SQL Cache Memory decreases and CPU usage increases when you rebuild an index for a table in SQL ServerSQL service
29060792962767 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 2012SQL performance
29060832963137 FIX: Incorrect result is returned when you query multiple dimension members in MDX and DAX in SSAS 2012Analysis Services
25566022963408 FIX: Error 5180 occurs when you query BLOB column data in SQL ServerSQL service
27827472963668 FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitionsSQL service
29060922965069 FIX: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012SQL performance
29061022965654 FIX: SSRS 2012 report is cut horizontally after you apply Update MS13-088 on a computerReporting Services
29060982965758 FIX: Memory leak occurs when you start and stop an XEvent session repeatedly in SQL Server 2012SQL service
29061002965922 FIX: Issue when you configure scheduled data refresh for the PowerPivot workbook in SharePoint 2013BI Azure
29060882967103 FIX: Service broker stops working when you unregister and remove a session in SQL ServerSQL service
27827502967240 FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL ServerSQL service
29061062967594 FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL Server 2012SQL service
29061082968909 FIX: Access violation when you query sys.extended_properties table in SQL Server 2012 or SQL Server 2014SQL service
29061102968914 FIX: Undetected deadlock occurs when you use a sequence object in SQL Server 2012SQL service
29061162970421 FIX: The database sticks in role configuration phase when you perform a manual failover of a mirrored databaseHigh Availability
29061182972411 FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012Reporting Services
29060962972463 FIX: Report cache is not cleaned up after the cache expiration when you use SSRS 2012 in SharePoint integrated modeReporting Services
29061202972996 FIX: Error when you execute a Transact-SQL query that contains a long case statement in SQL Server 2012SQL service
29061122973561 FIX: Error when you insert a record into a FileTable or FILESTREAM in SQL Server 2012 or SQL Server 2014SQL service
29061222973921 FIX: "allow mixed content" popup when you use PowerView that contains map data in SSRS 2012 on SharePoint websiteReporting Services
29060942975322 FIX: Blank value is set to NULL value in a business rule in MDS of SQL Server 2012 or SQL Server 2014Data Quality Services (DQS)
29060902975385 FIX: User obtains incorrect data when two users in the same security role run the same client report in SSAS 2012Analysis Services
29061252975498 FIX: Cannot view Power View sheet from SharePoint 2013 when a workbook uses certain Korean characters as file nameReporting Services
29061142976953 FIX: The DAX query with filter returns incorrect result after you run a DAX query without any filters in SSAS 2012Analysis Services
29061292976966 FIX: Cannot install the Windows Forms application that has ReportViewer control Reporting Services
29060862977271 FIX: Performance improvement for SQL Server Spatial data access in SQL Server 2012SQL service
27827562977312 FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL ServerSQL service
29061362979121 FIX: Log Reader Agent fails when you upgrade from SQL Server 2008 to SQL Server 2012 or SQL Server 2014SQL service
29061342979304 FIX: Error when you run RBS Maintainer in SQL Server 2012SQL service
29061322980395 FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server 2012SQL performance
28215532984249 FIX: Null fields are returned when the dataset in SSRS retrieves a stored procedure with required parametersReporting Services
30387752986423 FIX: It takes a long time to add new columns to a table when the row size exceeds the maximum allowed sizeSQL service
28903652986627 FIX: UPDATE STATISTICS performs incorrect sampling and processing for a table with columnstore index in SQL Server 2012SQL performance
27949822987809 FIX: Report format is misaligned when you view the report that has certain report items in Internet Explorer 11Reporting Services
28785932987812 FIX: No information about extensive lock conflicts in the SSAS msmdsrv.log fileAnalysis Services
28786002988166 FIX: Additional semicolons are added to object definition when you run Invoke-Sqlcmd in SQL Server 2012Management Tools
27187152989590 FIX: Except function does not return the calculated member that is created at the ALL member level in SSAS 2012Analysis Services
27196202989704 FIX: Some columns in sys.column_store_segments view show NULL value when the table has non-dbo schema in SQL ServerSQL service
29331432989810 FIX: Error when you use bcp_init to do BCP and use local temp table as input parameter in SQL Server Native Client 11.0SQL service
28873812991526 FIX: SSIS XML Source task fails to load the data from URI in SQL Server 2012Integration Services
28086592991528 FIX: SSIS package execution fails when it uses DT_TEXT data type after you apply SQL Server 2012 SP2Integration Services
27388132992069 FIX: XMLA and Windows PowerShell return different code for the same SSAS 2012 processing Analysis Services
28954442992414 FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSIS 2012Integration Services
29801112993262 FIX: Some rows are missing in the result when you run query to select data from Oracle linked server by using merge joinSQL performance
29492062993483 FIX: SSAS 2012 processing fails when you perform a Process Full operation on many partitions in a transactionAnalysis Services
30005202993529 FIX: Business rule validation fails with collation mismatch error in SQL Server 2012 MDS DQS

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 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:  

Cumulative update package information

Prerequisites

To apply this cumulative update package, you must be running SQL Server 2012 SP2.

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