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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://support.microsoft.com/kb/975756/ ) FIX: Toggled items display incorrectly when you print or export a SQL Server 2008 Reporting Services report
354793 975772 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 (http://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 - http://support.microsoft.com/kb/975977