Cumulative Update Package 5 for SQL Server 2008 Service Pack 1

Hi All,

Cumulative Update 5 for SQL Server 2008 Service Pack 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008 Service Pack 1.
Note This build of the cumulative update package is also known as build 10.00.2746.

We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

970365 (https://support.microsoft.com/kb/970365/ ) The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released

SQL Server 2008 hotfixes that are included in Cumulative Update 5 for SQL Server 2008 Service Pack 1

Microsoft Knowledge Base articles that discuss these hotfixes will be released as they become available.
For more information about the SQL Server bugs, click the following article numbers to view the articles in the Microsoft Knowledge Base:

360274
972893 (https://support.microsoft.com/kb/972893/ )
SQL Server 2008 Express supports .NET Framework 4 Beta 2 after you install Cumulative Update 5 for SQL Server 2008 Service Pack 1

339469
972937 (https://support.microsoft.com/kb/972937/ )
FIX: A performance issue in which SQL Server Management Studio checks the fragmentation data of an index in a large database

365457
973643 (https://support.microsoft.com/kb/973643/ )
FIX: The synchronization of a merge publication that uses Web synchronization takes a very long time to finish after the initial synchronization in SQL Server 2005 or in SQL Server 2008

365511
974067 (https://support.microsoft.com/kb/974067/ )
FIX: You use the COUNT function on a column that is returned by a subquery that returns no rows in SQL Server 2005 or in SQL Server 2008, and an incorrect result is returned

365463
974130 (https://support.microsoft.com/kb/974130/ )
FIX: A memory leak may occur if you use a linked server query to retrieve a sql_variant column from a remote server in SQL Server 2005 or in SQL Server 2008

365529
974205 (https://support.microsoft.com/kb/974205/ )
FIX: Error message in the Errorlog file of SQL Server 2005 or of SQL Server 2008 after the SQL Server service stops responding: "Timeout occurred while waiting for latch"

365468
974319 (https://support.microsoft.com/kb/974319/ )
FIX: Error message when you use database mirroring in SQL Server 2005 or in SQL Server 2008, and an assertion failure occurs intermittently: "SQL Server Assertion: File: <loglock.cpp>, line=823 Failed Assertion = 'result == LCK_OK'."

343231
974559 (https://support.microsoft.com/kb/974559/ )
FIX: Error message when you run a SQL Server 2008 Integration Services package that uses a configuration table in SQL Server Business Intelligence Development Studio: “The connection "<Connection Name>" is not found”

365482
974777 (https://support.microsoft.com/kb/974777/ )
FIX: Database restore operation may fail during the recovery phase when the database uses query notification in SQL Server 2005 or in SQL Server 2008

365475
974785 (https://support.microsoft.com/kb/974785/ )
FIX: An API cursor plan that is created by a plan guide is not reused when the cursor is active in SQL Server 2005 and in SQL Server 2008

362926
975027 (https://support.microsoft.com/kb/975027/ )
FIX: You take a long time to stop the SQL Server service and you cannot restart the SQL Server service in a Microsoft SQL Server 2008 cluster environment when the server is under stress

362619
975037 (https://support.microsoft.com/kb/975037/ )
FIX: Error message when two or more merge agents are trying to adjust a publisher identity range in parallel in SQL Server 2008: "Msg 548, The insert failed. It conflicted with an identity range check constraint"

365490
975089 (https://support.microsoft.com/kb/975089/ )
FIX: The restore operation takes a long time when you restore a database that has query notification enabled in SQL Server 2005 or in SQL Server 2008

365492
975090 (https://support.microsoft.com/kb/975090/ )
FIX: Deadlocks may occur when multiple concurrent query notification subscriptions are fired on same objects in SQL Server 2005 or in SQL Server 2008

365455
975134 (https://support.microsoft.com/kb/975134/ )
FIX: Capitalization and accent changes on a column of user-defined data type are not propagated in SQL Server 2005 merge replication or in SQL Server 2008 merge replication

365486
975159 (https://support.microsoft.com/kb/975159/ )
FIX: For SQL Server Compact Edition (CE) Subscribers, only schema without data is replicated for newly added articles to an existing Merge Publication using “ExchangeType.Upload”

351263
975284 (https://support.microsoft.com/kb/975284/ )
FIX: The mean and median lines are not shown when you view a report that contains a Boxplot chart in SQL Server 2008 Reporting Services

361096
975414 (https://support.microsoft.com/kb/975414/ )
FIX: The connection information is incorrect after you use "Change Connection" to connect to another server before the initial connection is completed in SQL Server Management Studio in SQL Server 2008

365470
975417 (https://support.microsoft.com/kb/975417/ )
FIX: A SELECT statement returns an incorrect result set if a linked server is being used in SQL Server 2005 or in SQL Server 2008

354975
975681 (https://support.microsoft.com/kb/975681/ )
FIX: The database mirroring session is suspended when you add more than one log transaction file to a folder on the principle server that does not exist on the mirror server in SQL Server 2005 or in SQL Server 2008

354794
975719 (https://support.microsoft.com/kb/975719/ )
FIX: An assertion failure may occur when you run a query that joins columns on a table with compression enabled in SQL Server 2008

365504
975748 (https://support.microsoft.com/kb/975748/ )
FIX: You cannot process an object when you change or delete another unrelated object at the same time in the same database in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services

355213
975756 (https://support.microsoft.com/kb/975756/ )
FIX: Toggled items display incorrectly when you print or export a SQL Server 2008 Reporting Services report

354793
975772 (https://support.microsoft.com/kb/975772/ )
FIX: An access violation occurs intermittently during message processing for service broker after you set up a database mirroring between two SQL Server 2008 servers

365509
975783 (https://support.microsoft.com/kb/975783/ )
FIX: You receive an incorrect result when you run an MDX query against a dimension that has a parent/child relationship after you install a cumulative update in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services

365513
975860 (https://support.microsoft.com/kb/975860/ )
FIX: A full backup with snapshot may cause SQL Server 2005 or SQL Server 2008 to stop responding

356786
975915 (https://support.microsoft.com/kb/975915/ )
FIX: An arithmetic overflow error occurs intermittently during the "Collect a snapshot of sys.dm_exec_query_stats" phase after you enabled data collector in SQL Server 2008

365515
976030 (https://support.microsoft.com/kb/976030/ )
FIX: Error message after you perform a Process Update on a dimension used on a cube that contains a writeback partition: "Errors in the high-level relational engine. The data source view does not contain a definition for the <tablename> table or view"

365506
976041 (https://support.microsoft.com/kb/976041/ )
FIX: You receive an incorrect result when you run a query that uses a parallel execution plan in SQL Server 2005 or in SQL Server 2008

359218
976124 (https://support.microsoft.com/kb/976124/ )
FIX: After you install SQL Server 2008 SP1 for the IA-64 version of SQL Server 2008 with Event Tracing for Windows (ETW) installed, SQL Server hangs during startup and cannot be started

360422
976231 (https://support.microsoft.com/kb/976231/ )
FIX: Error message when you install SQL Server 2008 Express edition on a computer that is running the Chinese Traditional version of Windows Vista for Hongkong: “Performance counter registry hive consistency”

361939
976359 (https://support.microsoft.com/kb/976359/ )
FIX: Error message when you export a report that uses the Code39(1:3) font to a .pdf file in SQL Server 2008 Reporting Services: “There was an error processing a page. There was a problem reading this document(135)”

353439
976367 (https://support.microsoft.com/kb/976367/ )
FIX: The Date data type may be corrupted when you use the SAP BI Destination component of Microsoft Connector 1.0 for SAP BI in a SQL Server 2008 Integration Services package

361363
976391 (https://support.microsoft.com/kb/976391/ )
FIX: A MDX query that involves multiple calculated measures may return an incorrect result in SQL Server 2008 Analysis Services

362130
976413 (https://support.microsoft.com/kb/976413/ )
FIX: Error message when you try to transfer data by using the Transfer object with the WithDependencies property enabled in SQL Server 2008: "Object reference not set to an instance of an object."

362019
976414 (https://support.microsoft.com/kb/976414/ )
FIX: Full-text search functionality does not work in SQL Server 2008 Express Edition even after you installed SQL Server 2008 CU2

364070
976603 (https://support.microsoft.com/kb/976603/ )
FIX: Different results may be returned when you concurrently run the same query with the RECOMPILE option in SQL Server 2008

365337
976761 (https://support.microsoft.com/kb/976761/ )
FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]"

367233
976935 (https://support.microsoft.com/kb/976935/ )
FIX: The execution of a parameterized CTE-based query takes a long time to complete in SQL Server 2008

347187
977058 (https://support.microsoft.com/kb/977058/ )
FIX: Cascading parameters have incorrect values after you customize the schedule for a new subscription on a SharePoint site of SQL Server 2008 Reporting Services

For more information, check out this Knowledge Base Article - https://support.microsoft.com/kb/975977

Nick.