Cumulative Update Package 5 for SQL Server 2008 Service Pack 1
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:
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:
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
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
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
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"
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'."
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”
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
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
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"
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
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
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
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”
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
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
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
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
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
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
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"
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
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”
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)”
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
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."
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]"
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