Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008.
Note This build of the cumulative update package is also known as build 10.00.1763.00.
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:
The SQL Server 2008 builds that were released after SQL Server 2008 was released
Important notes about the cumulative update
package
SQL Server 2008 hotfixes are now multilanguage. Therefore, there is only one cumulative hotfix package for all languages.
One cumulative hotfix package includes all the component packages. The cumulative update package
updates only those components that are installed on the system.
How to obtain Cumulative Update 1 for SQL Server 2008
A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2008 service pack that contains the hotfixes in this cumulative update package.
If the cumulative update is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.
Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
Note The "Hotfix Download Available" form displays the languages for which the cumulative update package is available. If you do not see your language, it is because a cumulative update package is not available for that language.
SQL Server 2008 hotfixes that are included in Cumulative Update 1 for SQL Server 2008
FIX: In SQL Server 2008, a query returns incorrect results for the Date data type when you run the query on a partitioned table that uses data compression on only one of the partitions
FIX: You receive an error message that states that the broker GUIDs do not match when you try to establish database mirroring in SQL Server 2008 or in SQL Server 2005
FIX: Error message when you try to run or preview a very large report in Microsoft SQL Server 2008 Reporting Services: "Exception of type System.OutOfMemoryException was thrown"
FIX: Error message when you try to view a report in SQL Server 2008 Reporting Services: "Object reference not set to an instance of an object. (rsRuntimeErrorInExpression)"
50003245
FIX: SQL Server 2008 Reporting Services stops responding when you try to render a report in the Image format
FIX: When you try to run a report that has recursive hierarchy and that uses toggles in the hierarchy, you may receive unpredictable results in SQL Server 2008 Reporting Services
FIX: A dump file may be generated in the Reporting Services Logfiles folder and you may receive an error message when you try to render a report in SQL Server 2008 Reporting Services
FIX: The Gauge report item uses only one point after you add multiple points to the item in SQL Server 2008 Reporting Services
50003249
FIX: Some items are split over two pages when you export a report to a PDF in SQL Server 2008 Reporting Services and you set the KeepTogether property
50003250
The embedded Tablix row and column size is not 100% for cells that contain data when a Tablix is embedded inside another Tablix in SQL Server 2008 Reporting Services
50003251
FIX: An image that is nested in a Tablix cell in SQL Server 2008 Reporting Services is displayed incorrectly when the Sizing property of the image is set to AutoSize
FIX: You receive an error message when you use the LoadReportDefinition API to view a drillthrough report or a subreport report in Report Builder in SQL Server 2008 Reporting Services
FIX: Error message when you try to create a query against a Hyperion Essbase cube database: "OLAP error (1260046): Unknown Member PARENT_UNIQUE_NAME used in query"
FIX: Error message when you run an MDX query that uses the CREATE GLOBAL CUBE statement to create a local cube in SQL Server 2008 Analysis Services or in SQL Server 2005 Analysis Services: "The syntax for '<MDXFunctionName>' is incorrect"
FIX: The SQL Server 2005 Distribution Agent and the SQL Server 2008 Distribution Agent do not skip error 20598 when you configure a SQL Server 2000 transactional publication to skip error 20598
FIX: An incorrect aggregate value is returned when you run an MDX query against a parent/child dimension that has the HideMemberIf property set to ParentIsBlankSelfOrMissing in SQL Server 2008 or in SQL Server 2005
50003334
FIX: Error message when you run an INSERT statement in SQL Server: "Cannot insert an explicit value into a timestamp column"
50003336
FIX: You cannot view calculated members in an Excel 2007 pivot table that references an OLAP table in SQL Server 2005 Analysis Services Service Pack 2 or in SQL Server 2008 Analysis Services
50003339
FIX: Error message when you run an MDX query in SQL Server 2008 Analysis Services: "The MDX function failed because the coordinate for the '<AttributeName>' attribute contains a set"
FIX: Error message when you update a table at the subscriber in a transactional replication in SQL Server 2008: "Updateable Subscriptions: Rows do not match between Publisher and Subscriber"
FIX: No rows are returned when you use the sp_replqueuemonitor stored procedure to list the queued messages for a queue-updating subscription in SQL Server
50003344
957872
FIX: When you update rows by using a cursor in SQL Server 2008, the update may take a long time to finish
FIX: Error message when you process a partition from SQL Server 2005 Analysis Services Cumulative Update 7 or from the release version of SQL Server 2008 Analysis Services: "Detected inconsistency between User define slice and detected slice of partition"
50003346
FIX: You receive a "Current session is no longer valid" error message or an access violation occurs when you process a cube in SQL Server 2008 Analysis Services
50003349
FIX: Error message when you run an UPDATE statement against a table that has a DML trigger in SQL Server 2008: "An inconsistency was detected during an internal operation"
50003350
Analysis Services may stop responding when a NonEmpty clause causes many cell
errors
FIX: The mining model opens a blank task editor window when you try to deploy the Data Mining Model Training task in a SQL Server 2008 Integration Services project in Business Intelligence Development Studio
FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key and there is a single row as the update source in SQL Server 2008
FIX: The IntelliSense feature does not work correctly for a database that uses the Turkish collation and that uses the case-insensitive collation sort order in SQL Server 2008
FIX: A NullReferenceException error for T-SQL Debugger occurs when you use the SET SHOWPLAN_XML ON option in a Transact-SQL statement on an instance of SQL Server 2008
FIX: You receive an error message when you click the View Single Column Profile By Column button in the Data Profile Viewer in SQL Server 2008: "Unhandled Exception"
FIX: The IntelliSense feature stops working when you type a query that has a specific lexical combination in SQL Server Management Studio in SQL Server 2008
FIX: In SQL Server 2008, the IntelliSense feature may become unavailable when you type Transact-SQL statements in the Query Editor in SQL Server Management Studio
50003382
FIX: Error message when you start the SQL Server 2008 Reporting Services Configuration Manager: "Invalid namespace"
50003383
FIX: The SimSun font is not displayed correctly when you view a SQL Server 2008 Report Services report
FIX: No records may be returned when you call the SQLExecute function to execute a prepared statement and you use the SQL Native Client ODBC Driver in SQL Server 2008
FIX: Error message when you install SQL Server 2008 Express edition on a domain controller that is running Windows Server 2003 SP2 or Windows Small Business Server 2003 SP1: "Exception has been thrown by the target of invocation"
FIX: When you install a clustered instance of SQL Server 2008, account validation fails even though you have specified the correct domain account and password
FIX: You receive an error message that the file is being used by another process when you try to rename or move an output file from a job in SQL Server Agent in SQL Server 2008
FIX: A new node is not added to a SQL Server 2008 Analysis Services cluster or a SQL Server 2008 Reporting Services cluster if the SQL Server 2008 Database Engine is not installed
FIX: Event ID 7904 is logged, and the SQL Server 2008 database is corrupted when you restore a SQL Server 2008 database from a sequence of transaction log backups
50003453
When you programmatically retrieve data from a SQL Server 2008 database, the data in memory may be overwritten
50003454
The Service Broker connections between endpoints may experience a deadlock condition when the initiator queues contain many messages
FIX: The Processes pane in the Activity Monitor incorrectly shows sessions as head blockers in SQL Server 2008
50003468
When a SQL Server 2008 policy file executes a WMI query, the policy always executes the query
against the local server regardless of the intended target
This cumulative update may not contain all the files that you must have to fully update a product to the latest build. This cumulative update contains only the files that you must have to correct the issue that is listed in this article.
The English version of this cumulative update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
32-bit versions
SQL Server 2008 Database Services Core Shared
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Distrib.exe
2007.100.1763.0
78,360
19-Sep-2008
09:43
x86
Dtspipeline.dll
2007.100.1763.0
697,368
19-Sep-2008
09:43
x86
Microsoft.sqlserver.dmf.dll
10.0.1763.0
295,960
19-Sep-2008
09:53
x86
Microsoft.sqlserver.management.collectortasks.dll
10.0.1763.0
87,064
19-Sep-2008
09:53
x86
Rdistcom.dll
2007.100.1763.0
652,312
19-Sep-2008
10:00
x86
Replmerg.exe
2007.100.1763.0
344,088
19-Sep-2008
10:00
x86
Sql_engine_core_shared_keyfile.dll
2007.100.1763.0
16,920
19-Sep-2008
09:52
x86
SQL Server 2008 Database Services Core Instance
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Datacollectorcontroller.dll
2007.100.1763.0
137,752
19-Sep-2008
09:42
x86
Mssqlsystemresource.ldf
Not applicable
524,288
18-Sep-2008
23:36
Not applicable
Mssqlsystemresource.mdf
Not applicable
63,242,240
18-Sep-2008
23:36
Not applicable
Sql_engine_core_inst_keyfile.dll
2007.100.1763.0
16,920
19-Sep-2008
09:52
x86
Sqlagent.exe
2007.100.1763.0
369,688
19-Sep-2008
10:14
x86
Sqlservr.exe
2007.100.1763.0
41,003,032
19-Sep-2008
10:14
x86
SQL Server 2008 Database Services Common Core
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Msgprox.dll
2007.100.1763.0
204,824
19-Sep-2008
09:53
x86
Replprov.dll
2007.100.1763.0
578,584
19-Sep-2008
10:00
x86
Replrec.dll
2007.100.1763.0
793,112
19-Sep-2008
10:00
x86
Sql_common_core_keyfile.dll
2007.100.1763.0
16,920
19-Sep-2008
09:52
x86
Xmlsub.dll
2007.100.1763.0
195,608
19-Sep-2008
10:15
x86
SQL Server 2008 Business Intelligence Development Studio
For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base: