At the outtage of Azure time Microsoft released two packs wit Cumulative Updates. Both for Microsoft SQL Server 2012 but for different versions. In this post I’ll write about update for SQL Server 2012 with Service Pack 2. In this Cumulative Update No 3 {build no 11.0.5556.0 } Microsoft fixed about forty bugs and here is the list. As you see the links are in different place than on my all previous posts. Beginning of this update, Microsoft SQL Server Service Team (which is responsible for publishing those informations) added link fo description of fixed bug instead of KB number. A little strange, but I don’t want to spend too much time for reformating all structure.
VSTS BUG: 3260585 | KB: 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server
SQL service
VSTS BUG: 3260585 | KB: 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server
SQL service
VSTS BUG: 3260587 | KB: 2975743
FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS
Analysis Services
VSTS BUG: 2785223 | KB: 2981424
FIX: Exception when you select more than one hierarchy from parent/child dimension with naming template in SSAS 2012
Analysis Services
VSTS BUG: 3336132 | KB: 2982019
FIX: Error when you restart the Merge Agent after you upgrade the Publisher to SQL Server 2012 SP2
SQL service
VSTS BUG: 3260583 | KB: 2982544
FIX: Slow to access "Explorer" or "System Administration" on MDM home page
Data Quality Services (DQS)
VSTS BUG: 3260593 | KB: 2986722
FIX: Error 7105 when you execute UPDATE on sparse column set while ONLINE INDEX REBUILD is running on the same table in SQL Server
SQL performance
VSTS BUG: 3260595 | KB: 2987935
FIX: Long wait on CLR_CRST when you execute spatial query that is under heavy load in SQL Server
SQL service
VSTS BUG: 3260589 | KB: 2988667
FIX: Query results keep unchanged when filter is applied in a parent-child dimension with unary operators in SSAS 2012
Analysis Services
VSTS BUG: 3260581 | KB: 2989043
FIX: Access denied when you view report history on a SharePoint site with the View Items permission
Reporting Services
VSTS BUG: 2921742 | KB: 2989478
FIX: Poor performance for cdc.fn_cdc_get_net_changes_<capture_instance> in SQL Server 2012 SP2
SQL performance
VSTS BUG: 3260577 | KB: 2989512
FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model
Analysis Services
VSTS BUG: 3260599 | KB: 2990152
FIX: Unexpected Simplified Chinese characters appear in TextData field of Distributed Replay trace in SQL Server
Management Tools
VSTS BUG: 3260575 | KB: 2994993
FIX: Text in a hyperlink in its own paragraph is not indexed in full-text in SQL Server 2012
SQL service
VSTS BUG: 3008500 | KB: 2995211
FIX: Incorrect error when you set rotation of chart series label greater than 90 or less than -90 in an SSRS 2012 report
Reporting Services
VSTS BUG: 3075681 | KB: 2995622
FIX: "Specified cast is not valid" error when you load an XML document that has time zone information in SSIS 2012
Integration Services
VSTS BUG: 3122214 | KB: 2996729
FIX: "Non-yielding Scheduler" condition occurs when you run a complex query in SQL Server 2012
SQL performance
VSTS BUG: 3134680 | KB: 2997392
FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012
SQL service
VSTS BUG: 3140832 | KB: 3000562
FIX: ImageConsolidation device information setting does not work when it is specified in the RSReportServer.config file
Reporting Services
VSTS BUG: 3203999 | KB: 3000835
FIX: "An internal error occurred on the report server" error when you export a report to a .pdf file in SSRS 2012
Reporting Services
VSTS BUG: 3187734 | KB: 3001713
FIX: The .csv file contains field separators when you export a report that has a tablix that has no data in SSRS 2012
Reporting Services
VSTS BUG: 3256393 | KB: 3002071
FIX: "System objects could not be updated…" error when you use AlwaysOn Availability Groups feature in SQL Server 2012
High Availability
VSTS BUG: 3277704 | KB: 3002883
FIX: Error in OpenFileStream API when you open FILESTREAM data that is hosted on dynamic disks in SQL Server 2012
SQL service
VSTS BUG: 3252239 | KB: 3003102
FIX: The date value in the Last Run column is blank in Report Manager Details View in SSRS 2012
Reporting Services
VSTS BUG: 3306817 | KB: 3004355
FIX: SQL Server crashes when you retrieve an SQL statement hash for logging XEvent in SQL Server 2012
SQL service
VSTS BUG: 3331484 | KB: 3006648
FIX: Data corruption occurs in target table when you use a SQL Server destination in a data flow component in SSIS 2012
SQL service
VSTS BUG: 3401421 | KB: 3008135
FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report
SQL service
VSTS BUG: 3406283 | KB: 3008416
FIX: Duplicate records in the report rendering when you use Lookup function in the expression of a matrix in SSRS 2012
Reporting Services
VSTS BUG: 3443909 | KB: 3009576
FIX: Cannot restore database by using the full backup and differential backup files that contain defunct files
SQL service
VSTS BUG: 3449716 | KB: 3009883
FIX: Error when you execute statistics update on a table that has sql_variant data type in SQL Server 2012
SQL performance
VSTS BUG: 3389698 | KB: 3010773
FIX: Power View report plots values incorrectly for line chart in SSRS 2012 in SharePoint integrated mode
SQL service
VSTS BUG: 3266265 | KB: 3011807
FIX: Large chain of blocking occurs when you use merge replication in SQL Server 2012
SQL service
VSTS BUG: 3343220 | KB: 3012182
FIX: Log_Send_Rate column in sys.dm_hadr_database_replica_states cannot reflect the rate accurately in SQL Server 2012
High Availability
VSTS BUG: 3012389 | KB: 3013553
FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012
SQL service
This update could be applied to Microsoft SQL Server 2012 Service Pack 2, when used with:
-
Microsoft SQL Server 2012 Enterprise
-
Microsoft SQL Server 2012 Developer
-
Microsoft SQL Server 2012 Express
-
Microsoft SQL Server 2012 Standard
-
SQL Server 2012 Reporting Services
-
Microsoft SQL Server 2012 Analysis Services
-
Microsoft SQL Server 2012 Business Intelligence
Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 3
You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering: 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 (This step requests servicerestart).
If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:
>> SQLServer2012_SP2_CU3_3002049_11_0_5556_x64
>> SQLServer2012_SP2_CU3_3002049_11_0_5556_x86
Enjoy!