Release of Cumulative Update packages – SQL Server 2008 R2 & SQL Server 2012


Here is the another instalment of Cumulative Update packages for both SQL Server 2008 R2 (SP1 and SP2) and SQL Server 2012 installations.

 

KBA2812683 talks about Cumulative Update package #11 for SQL Server 2008 R2 SP1 which includes both downloadable link and servicing model information, by applying this CU#11 the build number will be 10.50.2869.0. The following are list of fixes:

 

VSTS bug number KB article number Description
1028302 2760981 FIX: A PowerPivot workbook cannot connect to data source and load data when a PowerPivot server of a SharePoint farm is unavailable
1172951 2780146 FIX: “Incorrect syntax near ‘IDENTITY_VALUE'” error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2, SQL Server 2012 or in SQL Server 2008
1172947 2791745 FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008
1167751 2802113 FIX: “Failed Assertion = ‘CheckValidInput (wsName, cbName)'” error when you use database mirroring in Microsoft SQL Server 2008 R2

 

 

 

KBA2797460 talks about Cumulative Update package #5 for SQL Server 2008 R2 SP2 which includes both downloadable link and servicing model information, by applying this CU#5 the build number will be 10.50.4276.0. The following are list of fixes:

 

VSTS bug number KB article number Description
1155737 2734191 FIX: Reports are not printed in the defined page size when you use the RSClientPrint control to print reports in SSRS 2008 R2 or in SSRS 2012
1155740 2761400 FIX: An incomplete data import is reported as successful after a time-out in SSAS 2008 R2 or in SSAS 2012
1155750 2781486 FIX: Error messages when you perform a product update to a UCP-managed instance of SQL Server 2008 R2 or SQL Server 2012
1155756 2786212 FIX: Access violation occurs when you run a spatial query over a linked server in SQL Server 2008 R2 or in SQL Server 2012
1143163 2790668 FIX: Incorrect result when you use the BCP utility to export data from a SQL Server 2008 R2 instance to a data file
1145361 2791626 FIX: “Incorrect syntax near” error when you use a “datetimeoffset” type column as the partitioning column in SQL Server 2008 R2
1172948 2791745 FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008
1149775 2793580 FIX: An update is available that enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server 2008 R2
1148153 2794260 FIX: Session deadlock occurs when you use an Analysis Services personalization extension in SSAS 2008 R2
1161849 2800013 FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2
1162730 2800284 FIX: Incorrect result when you run an MDX query that includes an Aggregate function that is used in a calculated member in SSAS 2008 R2
1162588 2800797 FIX: Incorrect results when you run a FULL JOIN query that uses the CROSS APPLY clause in SQL Server 2008 R2
1172956 2802244 FIX: Installation or upgrade process fails when you install or upgrade a SQL Server 2008 clustered instance on mount points
1170316 2803799 FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2
1171295 2803994 FIX: Data corruption occurs when LOB data is loaded into a Transact-SQL variable in SQL Server 2008 R2
1150794 2806241 FIX: SSRS 2008 R2 report is not displayed if you set the PageBreak property for a group in SQL Server 2008 R2
1173669 2806244 FIX: Access violation when you restore transaction log backups in a SQL Server 2008 R2-based log shipping environment
1174229 2809198 FIX: Access violation after you run an ALTER statement to add a sparse column to a table in SQL Server 2008 R2
1156216 2809339 FIX: High memory usage or OOM error when you run an MDX query in SSAS 2008 R2 that uses the INT function
1165833 2809431 FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008 R2
1155747 972936 FIX: “SqlDumpExceptionHandler: Process <spid> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION.” error when you run a query in SQL Server 2012, in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005

 

 

KBA2728897 talks about Cumulative Update package #6 for SQL Server 2012  which includes both downloadable link and servicing model information, by applying this CU#6 the build number will be 11.0.2410.0. The following are list of fixes:

VSTS bug number KB article number Description
1155738 2734191 FIX: Reports are not printed in the defined page size when you use the RSClientPrint control to print reports in SSRS 2008 R2 or in SSRS 2012
1158565 2755192 FIX: SSMS freezes when you perform management operations that relate to roles to an SSRS 2008 R2 or SSRS 2012 database
1158567 2765785 FIX: Access violation when you execute an SSIS 2008 R2 or SSIS 2012 package that contains a Sort transformation on a computer that has multiple CPUs
1158569 2770258 FIX: You receive an incorrect result when you run a query against a partitioned table in SQL Server 2008 R2 or in SQL Server 2012
1169523 2770635 FIX: Incorrect result when you run an MDX query against an SSAS 2008 R2 or SSAS 2012 database that has multiple data sources
1087085 2772525 Improved Metadata Discovery process performance in SQL Server Native Client for SQL Server 2012
1158571 2776344 FIX: Deadlocks occur when you execute a stored procedure to alter a temporary table if lock partitioning is enabled in SQL Server 2008 R2 or in SQL Server 2012
1158573 2778479 FIX: 17066 and 3624 errors when you run the sp_refreshview stored procedure in a large batch that performs binary large object-related operations in SQL Server 2008 R2 or in SQL Server 2012
1158577 2780146 FIX: “Incorrect syntax near ‘IDENTITY_VALUE'” error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2, SQL Server 2012 or in SQL Server 2008
1158579 2781008 FIX: “User cannot be found” error message in SSRS 2008 R2 or in SSRS 2012 after the logon name is changed in Active Directory
1155751 2781486 FIX: Error messages when you perform a product update to a UCP-managed instance of SQL Server 2008 R2 or SQL Server 2012
1130624 2783983 FIX: Scroll bar moves too fast when you move components in the control flow or data flow designer window in SSDT 2012
1158587 2785079 FIX: A “non-yielding” error occurs on a server for Service Broker Message Forwarding in SQL Server 2008 R2 or in SQL Server 2012
1155757 2786212 FIX: Access violation occurs when you run a spatial query over a linked server in SQL Server 2008 R2 or in SQL Server 2012
1158591 2788362 FIX: Error 28921 and error 18054 when you start an instance of SQL Server 2008 R2 or SQL Server 2012 that is upgraded from SQL Server 7.0
1172949 2791745 FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008
988881 2800842 FIX: Performance improvement for the MDX query designer in SQL Server 2012 PowerPivot for Excel
1176644 2807974 FIX: Error 3456 after you add new file groups to the principal database in a SQL Server 2012 asynchronous database mirroring environment
1166623 2811020 FIX: Memory is not released when you use the Microsoft.SqlServer.XEvent.Linq assembly to read events in SQL Server 2012 Extended Events files
1155600 2811607 FIX: MDX query returns no results when a row-level security user runs an MDX query in SQL Server 2012
1155748 972936 FIX: “SqlDumpExceptionHandler: Process <spid> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION.” error when you run a query in SQL Server 2012, in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005
898456 980142 FIX: “Provider Load Failure” error message or the Wmiprvse.exe process stops responding when you use a SQL Server WMI provider to obtain information about SQL Server 2012, SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 services