Cumulative Update 3 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.2723.
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 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 3 for SQL Server 2008 Service Pack 1
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:
After you apply this cumulative update, you may encounter an issue when you try to use SQL Server
Management Studio to restore a SQL Server 2000 databases.
For more information about this issue, click the following article number to view the article in
the Microsoft Knowledge Base:
FIX: Error message when you restore a SQL Server 2000 database by using SQL Server 2005 Management Studio or SQL Server 2008 Management Studio: "Cannot show requested dialog. Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)"
After you apply this cumulative update, you may encounter an issue when you try to use SQL Server Agent. For more information about this issue, click the following article number to view the articles in the Microsoft Knowledge Base:
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]"
FIX: The SQL Server 2008 agent does not automatically resume running after you upgrade to SQL Server 2008 CU7 or SQL Server 2008 Service Pack 1 CU3/CU4 in a stand-alone environment
SQL Server 2008 hotfixes that are included in Cumulative Update 3 for SQL Server 2008 Service Pack 1
FIX: Error message is logged in the SQL Server 2008 Errorlog file when you perform operations on some temporary tables in SQL Server 2008: "Time out occurred while waiting for buffer latch"
FIX: Error message when you perform an online index rebuild operation for a table that has no clustered index in SQL Server 2008: "Location: pageref.cpp:913 Expression: IS_OFF"
FIX: Error message when you rebuild a table that has sparse columns in SQL Server 2008: "Cannot alter table '<TableName>' because the table either contains sparse columns or a column set column which are incompatible with compression"
FIX: Error message when you run a SQL Server 2008 Integration Services package that contains an Execute SQL Task that runs a stored procedure: "The type of the value being assigned to variable "<Variable>" differs from the current variable type"
FIX: SQL Server 2008 Report Designer renders numbers in an order opposite to what you expect when you add a special character to a Textbox control that contains both Hebrew characters and numbers
FIX: Error message when you run a query that uses the CASE function in SQL Server 2008: "Conversion failed when converting the <Type1> value ‘<A value>’ to data type <Type2>."
FIX: An assertion failure occurs when you switch the schedule of a report subscription between a shared schedule and a custom schedule in SQL Server 2005 Report Services or SQL Server 2008 Reporting Services
FIX: Error message when you run a job whose owner is a Windows user account after SQL Server 2005 Agent or SQL Server 2008 Agent is restarted: "The job failed. The owner () of job <Job Name> does not have server access"
FIX: Error message when you click the Columns tab in OLE DB Source Editor in SQL Server 2008 Integration Services: "Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR"
FIX: You receive inconsistent results when you run index-related DMVs to return statistical information about missing indexes in SQL Server 2005 or in SQL Server 2008
FIX: You receive an incorrect result when you query data from a linked server that is created by using an index OLE DB provider in SQL Server 2005 or in SQL Server 2008
FIX: Error message when you open a report by specifying a multivalued parameter in a URL in SQL Server 2005 or SQL Server 2008 Reporting Services: "Default value or value provided for the report parameter '<Parameter>' is not a valid value"
FIX: Error message when you open Replication Monitor for a transactional or merge publication in an instance of SQL Server 2008 that is an upgrade from SQL Server 2000: "Cannot insert the value NULL into column 'isagentrunningnow'"
FIX: The MAXDOP option for a running query or the max degree of parallelism option for the sp_configure stored procedure does not work in SQL Server 2008
FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: "Violation of PRIMARY KEY constraint '<PrimaryKey>'. Cannot insert duplicate key in object '<TableName>'"
FIX: Error message when you process the index for a partition in a cube in Microsoft SQL Server 2008 Analysis Services: "Internal error: An unexpected error occurred (file 'pffilestorefilegroup.cpp', line 1483, function 'PFFileStoreGroup::ReadPage')"
FIX: Error message when you run an MDX query that requests a dimension property on a parent-child hierarchy in Microsoft SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services
FIX: The data of a text box is missing when you print or export a SQL Server 2008 Reporting Services report that contains one or more subreports and one or more text boxes
FIX: A policy is evaluated against an incorrect target when you run the policy category in evaluation mode on a remote server that is running SQL Server 2008
FIX: CPU usage increases when you run a query that uses a string comparison function on a computer that has many processors after you upgrade to SQL Server 2005 Service Pack 3 or to SQL Server 2008
FIX: An MDX query that uses the NON EMPTY clause and the DrillDownLevel function returns null values in SQL Server 2005 Analysis Services or SQL Server 2008 Analysis Services
FIX: Error message when you run a SQL Server 2008 Reporting Services report in Business Intelligence Development Studio: "An item with the same key has already been added"
FIX: Error message when you run a SQL Server 2008-based application that calls the SQLBindParameter function: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"
FIX: An INSERT INTO <table name> EXEC <stored procedure name> statement generates error messages even if you set the ANSI_WARNINGS option to "OFF" in SQL Server 2008
FIX: Error message when you create a SharePoint subscription on a SQL Server 2008 Reporting Services report that uses cascading parameters: "This report requires a default or user-defined value for the report parameter '<Parameter>'"
FIX: The Data Profiling task shows "is_nullable" in the Control Flow window after you configure the Data Profiling task for a data source that uses the Turkish_CI_AS or Turkish_CS_AS collation in SQL Server 2008 Integration Services
FIX: Error message when you synchronize a database or manually run sp_replcmds after you perform partial updates on a varbinary(max) column in SQL Server 2008: "The rowset does not contain any column with offset -1."
FIX: Error message when you send an e-mail by using a private Database Mail profile in SQL Server 2005 or in SQL Server 2008: "profile name is not valid"
FIX: You cannot set up Data Collector on a SQL Server 2008 server if the server has a database that cannot be accessed or only allows restricted access
FIX: Error message when you process a partition in a measure group in SQL Server 2008 Analysis Services: "Errors in the high-level relational engine. The binding for the '<ColumnName>' column is not a ColumnBinding type"
Error message when you install the SharePoint add-in for the ClickOnce version of Microsoft SQL Server 2008 Report Builder 2.0 on an x64-based computer:"Reporting Services Add-in for SharePoint products and technologies is not installed
FIX: Error message when you process a very big dimension by using the Process Update option in SQL Server 2008: "File system error: While attempting to read information from disk, a read error occurred for physical file: <filename>, logical file"
FIX: When you query the DataSpaceUsed property or the IndexSpaceUsed property of a database that contains many tables in SQL Server 2008, the query takes a long time to finish
FIX: Error message when you try to add a filter for an index that includes columns in SQL Server 2008: "Add object to collection failed for IndexedColumnCollection of Index '<IndexName>'"
FIX: Error message when you try to disable Resource Governor by using the UI in SQL Server 2008 Management Studio after you drop a Resource Governor workload group: "Alter failed for ResourceGovernor 'Microsoft.SqlServer.Management.Smo.ObjectKeyBase'"
FIX: The “Copy Only Backup” option is still available even though you select the “Differential” option in the “Back Up Database” dialog box in SQL Server 2008 Management Studio
FIX: Error message when you press F1 to open the Device Contents help during a restore operation in SQL Server 2008: "Object reference not set to an instance of an object. (DqlManagerUI)"
FIX: The value of the Size property of the Smo.Server(<serverName>).Databases collection is incorrect after you install Microsoft SQL Server 2008 Service Pack 1
FIX: Error message when you run a MERGE statement on a table that has a unique clustered index and a nonclustered index in SQL Server 2008: "Cannot insert duplicate key row in object '<TableName>' with unique index '<IndexName>'"
FIX: The queries run very slowly when you run MDX queries in an application that uses the ADOMD.NET data provider through HTTP to connect to SQL Server 2008 Analysis Services
FIX: The SQL Server 2008 Analysis Services service crashes when you run an ALTER command on a database while an UPDATE CUBE statement is running on the database
FIX: An additional scrollbar appears when you use Outlook 2003 to open a SQL Server 2008 Reporting Services report that was sent in MHTML format to an e-mail subscription
FIX: Some columns are missing when you run a query against a table that is located on a linked server if the column names contain a period character in SQL Server 2008 Service Pack 1
FIX: You receive an incorrect result when you query a parent/child hierarchy that contains a single member on a level in Microsoft SQL Server 2008 Analysis Services
FIX: Error message when you create a local cube by using the SQL Server 2008 ADOMD.NET data provider in the x64-based version of Microsoft Office 2010: "Failed to initialize provider object"
FIX: A specified collation is displayed incorrectly when you use the Advanced/Enterprise installation mode to install a SQL Server 2008 failover cluster through the GUI
FIX: The SQL:BatchCompleted event and the RPC:Completed event displays an incorrect row count when you use SQL Server Profiler to monitor a sp_executesql stored procedure call in Microsoft SQL Server 2008
FIX: Error message when you install SQL Server 2008 or SQL Server 2008 Service Pack 1 on a Windows XP-based computer that has SQL Server 2000 installed: "Object reference not set to an instance of an object."
FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008
Note If you apply Cumulative Update 3 for SQL Server 2008 Service Pack 1 by using a slipstream installation, there is a known issue in the uninstall of the Full-Text Search engine when you uninstall this cumulative update.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
The Full-Text Search component is not completely rolled back to the Service Pack 1 version after you uninstall Cumulative Update 3 for SQL Server 2008 Service Pack 1 that is applied by using a slipstream installation
Cumulative update package information
Restart information
You may have to restart the computer after you apply this cumulative update.
Registry information
To use one of the hotfixes in this package, you do not have to make any changes to the registry.
This cumulative update package may not contain all the files that you must have to fully update a product to the latest build. This cumulative update package contains only the files that you must have to correct the issues that are listed in this article.
The English version of this cumulative update package 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 version
SQL Server 2008 Database Services Core Shared
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Commanddest.dll
2007.100.2723.0
164,696
11-Jul-2009
01:18
x86
Datacollectorenumerators.dll
2007.100.2723.0
69,464
11-Jul-2009
01:20
x86
Distrib.exe
2007.100.2723.0
75,096
11-Jul-2009
01:35
x86
Dtspipeline.dll
2007.100.2723.0
694,104
11-Jul-2009
01:35
x86
Dtswizard.exe
2007.100.2723.0
804,696
11-Jul-2009
01:35
x86
Exceldest.dll
2007.100.2723.0
173,400
11-Jul-2009
01:50
x86
Excelsrc.dll
2007.100.2723.0
183,128
11-Jul-2009
01:50
x86
Flatfiledest.dll
2007.100.2723.0
276,328
11-Jul-2009
01:52
x86
Flatfilesrc.dll
2007.100.2723.0
283,992
11-Jul-2009
01:52
x86
Iftsph.dll
2007.100.2723.0
38,248
11-Jul-2009
02:07
x86
Logread.exe
2007.100.2723.0
423,272
11-Jul-2009
02:47
x86
Microsoft.sqlserver.dmf.dll
10.0.2723.0
296,792
11-Jul-2009
02:52
x86
Microsoft.sqlserver.pipelinehost.dll
10.0.2723.0
71,512
11-Jul-2009
02:55
x86
Microsoft.sqlserver.sqlenum.dll
10.0.2723.0
1,083,240
11-Jul-2009
02:55
x86
Oledbdest.dll
2007.100.2723.0
173,912
11-Jul-2009
03:04
x86
Oledbsrc.dll
2007.100.2723.0
186,712
11-Jul-2009
03:04
x86
Rdistcom.dll
2007.100.2723.0
651,096
11-Jul-2009
03:21
x86
Repldp.dll
2007.100.2723.0
191,336
11-Jul-2009
03:21
x86
Replmerg.exe
2007.100.2723.0
341,336
11-Jul-2009
03:22
x86
Snapshot.exe
10.0.2723.0
13,160
11-Jul-2009
04:27
x86
Sql_engine_core_shared_keyfile.dll
2007.100.2723.0
13,656
11-Jul-2009
02:33
x86
Sqllogship.exe
10.0.2723.0
96,088
11-Jul-2009
04:28
x86
Sqlmergx.dll
2007.100.2723.0
192,872
11-Jul-2009
04:28
x86
Sqltaskconnections.dll
2007.100.2723.0
113,496
11-Jul-2009
04:29
x86
Txdataconvert.dll
2007.100.2723.0
206,680
11-Jul-2009
04:33
x86
SQL Server 2008 Database Services Core Instance
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Databasemailengine.dll
10.0.2723.0
75,608
11-Jul-2009
01:20
x86
Databasemailprotocols.dll
10.0.2723.0
42,840
11-Jul-2009
01:20
x86
Sql_engine_core_inst_keyfile.dll
2007.100.2723.0
13,656
11-Jul-2009
02:33
x86
Sqlaccess.dll
2007.100.2723.0
405,352
11-Jul-2009
04:27
x86
Sqlagent.exe
2007.100.2723.0
367,976
11-Jul-2009
04:27
x86
Sqlctr100.dll
2007.100.2723.0
72,552
11-Jul-2009
04:27
x86
Sqlscriptdowngrade.dll
2007.100.2723.0
14,680
11-Jul-2009
04:29
x86
Sqlscriptupgrade.dll
2007.100.2723.0
3,378,008
11-Jul-2009
04:29
x86
Sqlservr.exe
2007.100.2723.0
42,726,744
11-Jul-2009
04:29
x86
SQL Server 2008 Database Services Common Core
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Microsoft.analysisservices.adomdclient.dll
10.0.2723.0
546,648
11-Jul-2009
02:47
x86
Microsoft.analysisservices.dll
10.0.2723.0
1,316,696
11-Jul-2009
02:48
x86
Microsoft.analysisservices.xmla.dll
10.0.2723.0
227,160
11-Jul-2009
02:48
x86
Microsoft.sqlserver.sqlenum.dll
10.0.2723.0
1,083,240
11-Jul-2009
02:55
x86
Msgprox.dll
2007.100.2723.0
202,088
11-Jul-2009
02:57
x86
Replprov.dll
2007.100.2723.0
575,320
11-Jul-2009
03:22
x86
Replrec.dll
2007.100.2723.0
789,848
11-Jul-2009
03:22
x86
Replsub.dll
2007.100.2723.0
410,968
11-Jul-2009
03:22
x86
Sql_common_core_keyfile.dll
2007.100.2723.0
13,656
11-Jul-2009
02:33
x86
Xmlsub.dll
2007.100.2723.0
192,360
11-Jul-2009
04:34
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:
