It is Cumulative Update #2 for SQL Server 2005 Service Pack 3
Here is the time again for all (interested) DBAs & Admins to fold their sleeves again for further testing on Cumulative Update #2 for SQL Server 2005 SP3.
As you know SQL Server 2005 SP3 is released, so as the Cumulative Updates are back on road for your testing to keep the system up to date with update packages for SQL Server 2005 systems (latest pack of SP3). With this update package the following hotfixes are included (source:http://support.microsoft.com/kb/961930):
For more information about the SQL Server bugs, click the following article numbers to view the articles in the Microsoft Knowledge Base:
Collapse this tableExpand this table
| VSTS bug number |
KB article number |
Description |
| 266290 |
960971 (http://support.microsoft.com/kb/960971/ ) |
FIX: Error message when you run some Multidimensional Expressions (MDX) queries that reference some calculated members in many connections at the same time in SQL Server 2005 Analysis Services: "An unexpected error occurred" |
| 266298 |
960977 (http://support.microsoft.com/kb/960977/ ) |
FIX: Error message when you run a Multidimensional Expressions (MDX) query that contains a calculation in SQL Server 2005 Analysis Services: "An unexpected exception occurred" |
| 271683 |
961146 (http://support.microsoft.com/kb/961146/ ) |
FIX: You cannot connect to an instance of SQL Server 2005 Analysis Services through HTTP when you configure Internet Explorer to use a .pac file |
| 263148 |
961479 (http://support.microsoft.com/kb/961479/ ) |
FIX: An unresolved deadlock occurs when you perform an online reindex operation that runs on parallel threads in SQL Server 2005 |
| 273948 |
961648 (http://support.microsoft.com/kb/961648/ ) |
FIX: You receive an error message when you try to query or update a column of large object (LOB) data in SQL Server 2005 |
| 271942 |
961920 (http://support.microsoft.com/kb/961920/ ) |
FIX: A syntax error occurs when you try to use the lift chart to validate a mining model that uses an Oracle data source in SQL Server 2005 Analysis Services |
| 271563 |
961935 (http://support.microsoft.com/kb/961935/ ) |
FIX: A query notification is not fired correctly if the query contains inner joins and the IS NULL clause in SQL Server 2005 |
| 263205 |
962003 (http://support.microsoft.com/kb/962003/ ) |
FIX: Error message when you synchronize data for a SQL Server Compact Edition subscriber in SQL Server 2005: "A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006)" |
| 271522 |
962209 (http://support.microsoft.com/kb/962209/ ) |
FIX: Error message when you run an UPDATE statement on a database that has the SNAPSHOT or READ COMMITTED SNAPSHOT isolation level enabled in SQL Server 2005: "The Database ID <Database ID>, Page (<N>:<N>), slot <N> for LOB data type node does not exist" |
| 274802 |
963684 (http://support.microsoft.com/kb/963684/ ) |
FIX: The execution plan does not use the forced index when you use the INDEX optimizer hint in a query that runs against a synonym in SQL Server 2005 |
| 275647 |
967164 (http://support.microsoft.com/kb/967164/ ) |
FIX: The SQL Server service crashes, and you receive error 1450 when you create database snapshot or run a DBCC CHECK statement on a database in SQL Server 2005 |
| 276993 |
967180 (http://support.microsoft.com/kb/967180/ ) |
FIX: You are prompted to provide the credentials when you view a history snapshot for a SQL Server 2005 Reporting Services report if you use stored credentials for the data source of the report |
As per the KBA961930 advice keep a close-eye on this information:
Restart information
loadTOCNode(3, 'moreinformation');
You may have to restart the computer after you apply this cumulative update package.
Registry information
loadTOCNode(3, 'moreinformation');
To use one of the hotfixes in this package, you do not have to make any changes to the registry.
So take your time to go through this update package.