INTRODUCTION
This article describes cumulative update package 3 for Microsoft SQL Server 2012 Service Pack 1 (SP1). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP1.
Note The build number of the cumulative update package is 11.0.3349.0. We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2012 update release. We recommend that you consider applying the most recent update release. For more information, click the following article number to view the article in the Microsoft Knowledge Base:2772858 The SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 1 was released
Important notes about this cumulative update package
-
SQL Server 2012 SP1 hotfixes are now multilingual. Therefore, this cumulative update package is not specific to one language. It applies to all supported languages.
-
One cumulative update package includes all the component packages. However, the cumulative update package updates only those components that are installed on the system.
More Information
How to obtain this cumulative update package
A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2012 service pack that contains the hotfixes in this cumulative update package.
If the cumulative update is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package. Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, go to the following Microsoft website:http://support.microsoft.com/contactus/?ws=supportNote The "Hotfix Download Available" form displays the languages for which the cumulative update is available. If you do not see your language, it is because a cumulative update package is not available for that language.
Hotfixes that are included in this cumulative update package
Microsoft Knowledge Base articles that discuss these hotfixes will be released as they become available.
For more information about the SQL Server issues, click the following article numbers to view the articles in the Microsoft Knowledge Base:
VSTS bug number |
KB article number |
Description |
---|---|---|
1158566 |
FIX: SSMS freezes when you perform management operations that relate to roles to an SSRS 2008 R2 or SSRS 2012 database |
|
1155742 |
FIX: An incomplete data import is reported as successful after a time-out in SSAS 2008 R2 or in SSAS 2012 |
|
1169525 |
FIX: The DateTime parameter is not displayed by using the regional setting format of a SharePoint website in SSRS 2012 |
|
1169524 |
FIX: Incorrect result when you run an MDX query against an SSAS 2008 R2 or SSAS 2012 database that has multiple data sources |
|
1201576 |
Improved Metadata Discovery process performance in SQL Server Native Client for SQL Server 2012 |
|
1201571 |
FIX: Scroll bar functionality too sensitive when you drag components in the control flow or data flow designer window in SSDT |
|
1145230 |
FIX: Security token leak occurs when you run more than two PowerShell steps by using a proxy account in a SQL Server Agent job |
|
1172950 |
FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008 or in SQL Server 2012 |
|
1207361 |
FIX: Session deadlock occurs when you use an Analysis Services personalization extension in SSAS 2008 R2 or in SSAS 2012 |
|
1207371 |
FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2 or in SQL Server 2012 |
|
1207373 |
FIX: Incorrect results when you run a FULL JOIN query that uses the CROSS APPLY clause in SQL Server 2008 R2 or in SQL Server 2012 |
|
1201575 |
FIX: Performance improvement for the MDX query designer in SQL Server 2012 PowerPivot for Excel |
|
1167499 |
FIX: You cannot open a PowerPivot workbook after you install SQL Server 2012 SP1 PowerPivot for Excel |
|
1168983 |
FIX: Memory leak when you run queries against a temporary table in a nested stored procedure in SQL Server 2012 |
|
1170481 |
FIX: Poor performance in SQL Server 2012 when you run a SQL Server trace |
|
1207379 |
FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2 or in SQL Server 2012 |
|
1171274 |
FIX: "Errors in cell writeback" message when you run UPDATE CUBE statements after you upgrade to SSAS 2012 |
|
1207381 |
FIX: Data corruption occurs when LOB data is loaded into a Transact-SQL variable in SQL Server 2008 R2 or in SQL Server 2008 |
|
1207383 |
FIX: Access violation when you restore transaction log backups in a SQL Server 2008 R2-based or SQL Server 2012-based log shipping environment |
|
1174860 |
FIX: Error when you open a tabular model file in SQL Server 2012 |
|
1175459 |
FIX: You experience poor performance when you run a query against an RCSI-enabled table in SQL Server 2012 |
|
1175526 |
FIX: Dimension property is not translated correctly when you query the property by using an MDX query that has the tabular format configured in SSAS 2012 |
|
1201573 |
FIX: Error 3456 after you add new file groups to the principal database in a SQL Server 2012 asynchronous database mirroring environment |
|
1150340 |
FIX: Error when you edit the connection string in Analysis Services Deployment Wizard tool after you apply SQL Server 2012 SP1 |
|
1183628 |
FIX: High "log write waits" counter value on a SQL Server 2012 node |
|
1207367 |
FIX: High memory usage or OOM error when you run an MDX query in SSAS 2008 R2 or in SSAS 2012 that uses the INT function |
|
1161808 |
FIX: Memory is not released when you use the Microsoft.SqlServer.XEvent.Linq assembly to read events in SQL Server 2012 Extended Events files |
|
1201572 |
FIX: MDX query returns no results when a row-level security user runs an MDX query in SQL Server 2012 |
|
1165556 |
FIX: Access violation and error 2905 when you run a Service Broker application in SQL Server 2012 |
|
1186917 |
FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server |
|
1190509 |
FIX: Value of the NORECOMPUTE property for a partitioned index is not retained after you rebuild the index in SQL Server 2012 |
|
1200058 |
FIX: Incorrect background color returned if you export an SSRS 2012 report to Microsoft Excel |
|
1195332 |
FIX: Incorrect decimal separator is used when you browse data in MDS in SQL Server 2012 |
|
1195802 |
FIX: Business rule does not work when a member code contains some special characters in MDS in SQL Server 2012 |
|
1136313 |
SQL Server 2012 experiences performance issues in NUMA environments |
|
1201432 |
FIX: SSAS 2012 freezes when a scheduled data update starts while you run complex DAX queries |
|
1182790 |
FIX: "The MDX function failed because the coordinate for the 'AttributeName' attribute contains a set." message when you run an MDX query in SQL Server 2012 |
|
1207377 |
FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008, SSAS 2008 R2 or SSAS 2012 |
Cumulative update package information
Prerequisites
To apply this cumulative update package, you must be running SQL Server 2012 SP1.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:2755533 How to obtain the latest service pack for SQL Server 2012
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.
How to uninstall this cumulative update package
To uninstall this cumulative update package, follow these steps:
-
In Control Panel, open the Add or Remove Programs item.
Note If you are running Windows 7, open the Programs and Features item in Control Panel. -
Locate the entry that was installed by this cumulative update package.
-
Right-click the entry, and then click Uninstall.
References
For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
822499 Naming schema for Microsoft SQL Server software update packages For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates