Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 2 hotfix to an installation of SQL Server 2005 Service Pack 2. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.
Cumulative Update 3 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2.
Note This build of the cumulative update package is also known as build 3186.
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 2005 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 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
Important notes about the cumulative update package
SQL Server 2005 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.
You must enable the SQL Server Management Object (SMO) extended stored procedures and the SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you apply the cumulative update package. For more information about the SMO and DMO XPs option, see SQL Server 2005 Books Online.
Note SQL Server 2005 Books Online notes that the default setting of these stored procedures is 0 (off). However, this value is incorrect. By default, the setting is 1 (on).
How to obtain Cumulative Update 3 for SQL Server 2005 Service Pack 2
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 2005 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 is available. If you do not see your language, it is because a cumulative update package is not available for that language.
Known issues
For more information about the issue that occurs when Cumulative Update 3 for SQL Server 2005 Service Pack 2 unregisters the Dts.dll file on a computer that has a 64-bit processor, click the following article number to view the article in the Microsoft Knowledge Base:
On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan
FIX: Error message when you use Database Engine Tuning Advisor to tune a database in SQL Server 2005 Service Pack 2: "An unhandled win32 exception occurred in dtaengine90.exe [4308]"
FIX: Error message when you connect to an instance of SQL Server 2008 Analysis Services by using the AMO library that is included with SQL Server 2005 Service Pack 2 Analysis Services: "Cannot connect to Analysis Services version '10.0.1600.22'"
FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:”Insufficient memory to continue the execution of the program”
FIX: The event information that is generated by a child package does not have a "User:" prefix in Integration Services in SQL Server 2005 Service Pack 2
FIX: Error message when you run a query that selects many columns and that joins many tables in SQL Server 2005 Service Pack 2: "The query processor could not produce a query plan"
FIX: The performance of an MDX query that contains subselect queries and calculated members is much slower in SQL Server 2005 Analysis Services Service Pack 2 than in the earlier versions of SQL Server 2005 Analysis Services
FIX: The performance of an MDX query in SQL Server 2005 Analysis Services Service Pack 2 is much slower than the performance of the same query in earlier builds of SQL Server 2005 Analysis Services
FIX: Error message when you use the Bcp.exe utility together with the queryout option in Microsoft SQL Server 2005: "BCP host-files must contain at least one column"
FIX: Error message when you use Service Broker in SQL Server 2005: "An error occurred while receiving data: '64(The specified network name is no longer available.)'"
FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: "String or binary data would be truncated"
FIX: Error message when you back up a database to a tape device in Microsoft SQL Server 2005 SP2: "Operation on device 'TAPE0(\\.\Tape0)' exceeded retry count" or "BackupTapeFile::UnloadTape: PrepareTape failure on backup device '\\.\Tape0'"
FIX: Error message when you run a SQL Server 2005 Integration Services package that contains an FTP task: "An error occurred in the requested FTP operation"
FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message"
FIX: Error message when you try to insert more than 3 megabytes of data into a distributed partitioned view in SQL Server 2005: "A system assertion check has failed"
FIX: Error message when you synchronize a subscription by using Windows Synchronization Manager in SQL Server 2005: "The merge process failed to get correct information about the Interactive Resolver component from the Registry"
50001461
When some MDX queries are executed at the same for the same role or for the same user in SQL Server 2005 Analysis Services, the CPU usage is very high
FIX: You receive a System.InvalidCastException exception when you run an application that calls the Server.JobServer.Jobs.Contains method on a computer that has SQL Server 2005 Service Pack 2 installed
FIX: You cannot install the SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies on a computer that is running a beta version of Windows Server 2008
FIX: Error message when you deploy a SQL Server 2005 Analysis Service project that contains many cubes, and the cubes contain linked measure groups: "Unexpected internal error"
FIX: Error message when you display a report that uses SAP Business Information Warehouse 3.5 as the data source in SQL Server 2005 Service Pack 2 Reporting Services: "Can't find object <Object ID>"
FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: "Internal Query Processor Error The query processor could not produce a query plan"
FIX: Error message when you synchronize a merge replication in Microsoft SQL Server 2005: "MSmerge_del_<GUID>, Line 42 String or binary data would be truncated"
FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005
FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exec_sessions dynamic management view in SQL Server 2005
FIX: Error message when you process a database in SQL Server 2005 Analysis Services: "Failed generate and process of Olap object(s): Internal error: The operation terminated unsuccessfully"
FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"
FIX: Error message when you run a full-text query against a catalog in SQL Server 2005: "The execution of a full-text query failed. The content index is corrupt."
FIX: You receive an error message when you try to access a report after you configure SQL Server 2005 Reporting Services to run under the SharePoint integrated mode
FIX: An MDX query does not return results when you execute the query against a cube that contains an unnatural hierarchy in a dimension in SQL Server 2005 Analysis Services
FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: "SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'"
FIX: You cannot roll back changes in a transaction after you call the ITransactionLocal::Abort method by setting the fRetaining flag to TRUE in a SQL Server 2005-based application that uses the SQL Native Client OLE DB provider
FIX: Error message when you try to update the index key columns of a non-unique clustered index in SQL Server 2005: "Cannot insert duplicate key row in object 'ObjectName' with unique index 'IndexName'"
FIX: When you roll back a transaction that contains a writeback operation, SQL Server does not roll back the writeback operation in SQL Server 2005 Analysis Services
FIX: Error message when you run a stored procedure that references tables after you upgrade a database from SQL Server 2000 to SQL Server 2005: "A time-out occurred while waiting for buffer latch"
FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005
How to obtain the latest service pack for SQL Server 2005
Restart information
You may have to restart the computer after you apply this cumulative update package.
Registry information
To use one of the hotfixes in this package, you do not have to make any changes to the registry.
Cumulative update package file information
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.
SQL Server 2005 Database Engine, 32-bit version
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Bcp.exe
2005.90.3186.0
68,976
11-Aug-07
10:19
x86
Chsbrkr.dll
12.0.7822.0
1,684,840
22-Jun-07
9:22
x86
Chtbrkr.dll
12.0.7822.0
6,112,616
22-Jun-07
9:22
x86
Databasemailprotocols.dll
9.0.3186.0
46,448
11-Aug-07
10:19
x86
Dts.dll
2005.90.3186.0
1,102,192
11-Aug-07
10:19
x86
Dtsconn.dll
2005.90.3186.0
250,736
11-Aug-07
10:19
x86
Fteref.dll
12.0.7822.0
446,464
22-Jun-07
9:22
x86
Infosoft.dll
12.0.7822.0
468,328
22-Jun-07
9:22
x86
Korwbrkr.dll
12.0.7822.0
71,016
22-Jun-07
9:22
x86
Langwrbk.dll
12.0.7822.0
136,552
22-Jun-07
9:22
x86
Microsoft.analysisservices.dll
9.0.3186.0
1,217,904
11-Aug-07
10:19
x86
Microsoft.sqlserver.dtstransferprovider.dll
9.0.3186.0
116,080
11-Aug-07
10:19
x86
Microsoft.sqlserver.maintenanceplantasks.dll
9.0.3186.0
296,304
11-Aug-07
10:19
x86
Microsoft.sqlserver.smo.dll
9.0.3186.0
1,598,832
11-Aug-07
10:19
x86
Microsoft.sqlserver.sqlenum.dll
9.0.3186.0
906,608
11-Aug-07
10:19
x86
Msfte.dll
12.0.7822.0
2,430,312
22-Jun-07
9:22
x86
Msftefd.exe
12.0.7822.0
66,920
22-Jun-07
9:22
x86
Msftepxy.dll
12.0.7822.0
95,592
22-Jun-07
9:22
x86
Msftesql.exe
12.0.7822.0
95,592
22-Jun-07
9:22
x86
Msir5jp.dll
5.0.2130.0
3,159,912
22-Jun-07
9:22
x86
Msmdlocal.dll
9.0.3186.0
15,955,312
11-Aug-07
10:19
x86
Nlhtml.dll
12.0.7822.0
124,264
22-Jun-07
9:22
x86
Nls400.dll
5.0.4217.0
12,240,744
22-Jun-07
9:22
x86
Odsole70.dll
2005.90.3186.0
59,248
11-Aug-07
10:19
x86
Query.dll
12.0.7822.0
48,488
22-Jun-07
9:22
x86
Rdistcom.dll
2005.90.3186.0
644,976
11-Aug-07
10:19
x86
Replmerg.exe
2005.90.3186.0
320,880
11-Aug-07
10:19
x86
Replrec.dll
2005.90.3186.0
785,264
11-Aug-07
10:19
x86
Sqlaccess.dll
2005.90.3186.0
350,576
11-Aug-07
10:19
x86
Sqlagent90.exe
2005.90.3186.0
349,552
11-Aug-07
10:19
x86
Sqlservr.exe
2005.90.3186.0
29,202,800
11-Aug-07
10:20
x86
Sqlwep.dll
2005.90.3186.0
90,992
11-Aug-07
10:20
x86
Sqsrvres.dll
2005.90.3186.0
70,512
11-Aug-07
10:20
x86
Thawbrkr.dll
12.0.7822.0
206,184
22-Jun-07
9:22
x86
Xmlfilt.dll
12.0.7822.0
197,992
22-Jun-07
9:22
x86
Xpstar90.dll
2005.90.3186.0
298,864
11-Aug-07
10:20
x86
SQL Server 2005 Analysis Services, 32-bit version
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
Microsoft.analysisservices.dll
9.0.3186.0
1,217,904
11-Aug-07
10:19
x86
Microsoft.datawarehouse.dll
9.0.3186.0
1,279,344
11-Aug-07
10:19
x86
Microsoft.sqlserver.smo.dll
9.0.3186.0
1,598,832
11-Aug-07
10:19
x86
Microsoft.sqlserver.sqlenum.dll
9.0.3186.0
906,608
11-Aug-07
10:19
x86
Msadomdx.dll
9.0.3186.0
502,640
11-Aug-07
10:19
x86
Msmdlocal.dll
9.0.3186.0
15,955,312
11-Aug-07
10:19
x86
Msmdspdm.dll
9.0.3186.0
202,096
11-Aug-07
10:19
x86
Msmdsrv.exe
9.0.3186.0
14,923,632
11-Aug-07
10:19
x86
Msmgdsrv.dll
9.0.3186.0
6,045,552
11-Aug-07
10:19
x86
Msolap90.dll
9.0.3186.0
4,299,120
11-Aug-07
10:19
x86
SQL Server 2005 Reporting Services, 32-bit version
For more information about how to apply a hotfix for SQL Server 2005 in a replication topology, click the following article number to view the article in the Microsoft Knowledge Base:
How to apply a hotfix for SQL Server 2005 in a replication topology
For more information about the list of builds that are available after SQL Server Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
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 how to obtain SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
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:
Back to the top
