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 6 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 3228.
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:
937137 (http://support.microsoft.com/kb/937137/)
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).
Known issue in Cumulative Update 6 for SQL Server 2005 Service Pack 2
When you update a service property in SQL Server Configuration Manager after you install Cumulative Update 6 for SQL Server 2005 Service Pack 2, you receive the following error message in the WMI Provider Error dialog box:
The server threw an exception. [0x80010105]
Additionally, you may receive the following error message:
Connection to target machine could not be made in a timely fashion
You can still update a service property in the Services snap-in. However, if the service is a clustered service, we do not recommend that you update properties of the service in the Services snap-in. We highly recommend that you update properties in the SQL Server Configuration Manager.
The fix for this issue was first released in Cumulative Update 7.
For more information about how to obtain Cumulative Update 7, click the following article number to view the article in the Microsoft Knowledge Base:
949095 (http://support.microsoft.com/kb/949095/)
Cumulative update package 7 for SQL Server 2005 Service Pack 2
How to obtain Cumulative Update 6 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.
FIX: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: "The product instance <InstanceName> been patched with more recent updates"
FIX: The Wmiprvse.exe host process may stop unexpectedly when you run the application that uses the Microsoft Windows Management Instrumentation (WMI) provider to monitor an instance of SQL Server 2005
FIX: A calculation script that calculates the same cells several times may return an incorrect result in SQL Server 2005 Analysis Services Service Pack 2
FIX: SQL Server 2005 Analysis Services stops responding when you run an MDX query that references a measure of the double data type or a calculated member of the double data type
FIX: A report has a dual file name extension when you send the report though e-mail subscriptions in the Excel format or in the PDF format in the SQL Server 2005 Reporting Services SharePoint integrated mode
FIX: A distribution database may grow continuously on one of the nodes when you configure a peer-to-peer transactional replication in SQL Server 2005 Service Pack 2
FIX: Error messages when you delete some records of a table in a transaction or when you update some records of a table in a transaction in SQL Server 2005: "Msg 9002," "Msg 3314," and "Msg 9001"
FIX: The columns of the XML data type are replicated as empty strings in a merge replication that uses a merge filter of the logical record relationship type in SQL Server 2005
FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: "A severe error occurred on the current command"
FIX: Error message when you try to connect to a named instance of SQL Server 2005 Analysis Services: "The '<InstanceName>' instance was not found on the '<ServerName>' server"
FIX: Error message when you start a database mirroring session in SQL Server 2005: "Communications to the remote server instance 'TCP://<ComputerName>:<PortNumber>' failed before database mirroring was fully started"
FIX: A blocking issue occurs when you update rows in a table in SQL Server 2005
50002272
You cannot connect to the report server in Reporting Services Configuration Manager after you set the application pool of the report server and of the report manager
50002299
You obtain the incorrect result for two Lookup transformations that reference the same dataset if the order of the input columns is different
FIX: The used space in the tempdb database increases continuously when you run a query that creates internal objects in the tempdb database in SQL Server 2005
50002318
Error message when you execute an ALTER INDEX statement together with the REORGANIZE option: "Server is terminating"
FIX: The CONTEXT_INFO function returns the old value of the context information after you call a stored procedure that contains a TRY-CATCH block from a SQL Server CLR function
FIX: An access violation occurs when you run an MDX query by using a user account that is a member of some different roles in SQL Server 2005 Analysis Services
FIX: Error message when the workload demand on the server is high in SQL Server 2005 Analysis Services: "Internal error: An unexpected exception occured"
FIX: Error message when you perform a processing operation or a query operation in SQL Server 2005 Analysis Services: "Error 0xC1020034. The following file is corrupted"
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
913089 (http://support.microsoft.com/kb/913089/LN/) 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
File name
File version
File size
Date
Time
Platform
Bcp.exe
2005.90.3228.0
68,632
09-Feb-2008
18:12
x86
Chsbrkr.dll
12.0.7822.0
1,684,840
22-Jun-2007
9:22
x86
Chtbrkr.dll
12.0.7822.0
6,112,616
22-Jun-2007
9:22
x86
Databasemailprotocols.dll
9.0.3228.0
46,104
09-Feb-2008
18:12
x86
Distrib.exe
2005.90.3228.0
70,680
09-Feb-2008
18:12
x86
Dts.dll
2005.90.3228.0
1,102,360
09-Feb-2008
18:12
x86
Dtsconn.dll
2005.90.3228.0
250,392
09-Feb-2008
18:12
x86
Dtspipeline.dll
2005.90.3228.0
605,208
09-Feb-2008
18:12
x86
Fteref.dll
12.0.7822.0
446,464
22-Jun-2007
9:22
x86
Infosoft.dll
12.0.7822.0
468,328
22-Jun-2007
9:22
x86
Korwbrkr.dll
12.0.7822.0
71,016
22-Jun-2007
9:22
x86
Langwrbk.dll
12.0.7822.0
136,552
22-Jun-2007
9:22
x86
Mergetxt.dll
2005.90.3228.0
32,280
09-Feb-2008
18:12
x86
Microsoft.Analysisservices.dll
9.0.3228.0
1,217,560
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Connectioninfo.dll
9.0.3228.0
156,696
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Dtstransferprovider.dll
9.0.3228.0
115,736
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Maintenanceplantasks.dll
9.0.3228.0
295,960
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Replication.dll
2005.90.3228.0
1,628,184
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Servicebrokerenum.dll
9.0.3228.0
42,008
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Smo.dll
9.0.3228.0
1,606,680
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Smoenum.dll
9.0.3228.0
222,232
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Sqlenum.dll
9.0.3228.0
898,072
09-Feb-2008
18:12
x86
Msfte.dll
12.0.7822.0
2,430,312
22-Jun-2007
9:22
x86
Msftefd.exe
12.0.7822.0
66,920
22-Jun-2007
9:22
x86
Msftepxy.dll
12.0.7822.0
95,592
22-Jun-2007
9:22
x86
Msftesql.exe
12.0.7822.0
95,592
22-Jun-2007
9:22
x86
Msgprox.dll
2005.90.3228.0
200,216
09-Feb-2008
18:12
x86
Msir5Jp.dll
5.0.2130.0
3,159,912
22-Jun-2007
9:22
x86
Msmdlocal.dll
9.0.3228.0
15,969,304
09-Feb-2008
18:12
x86
Msmdredir.dll
9.0.3228.0
4,022,808
09-Feb-2008
18:12
x86
Nlhtml.dll
12.0.7822.0
124,264
22-Jun-2007
9:22
x86
Nls400.dll
5.0.4217.0
12,240,744
22-Jun-2007
9:22
x86
Odsole70.dll
2005.90.3228.0
58,904
09-Feb-2008
18:12
x86
Osql.exe
2005.90.3228.0
53,272
09-Feb-2008
18:12
x86
Query.dll
12.0.7822.0
48,488
22-Jun-2007
9:22
x86
Rdistcom.dll
2005.90.3228.0
644,632
09-Feb-2008
18:12
x86
Replerrx.dll
2005.90.3228.0
114,712
09-Feb-2008
18:12
x86
Replisapi.dll
2005.90.3228.0
272,920
09-Feb-2008
18:12
x86
Replmerg.exe
2005.90.3228.0
320,536
09-Feb-2008
18:12
x86
Replprov.dll
2005.90.3228.0
552,984
09-Feb-2008
18:12
x86
Replrec.dll
2005.90.3228.0
785,432
09-Feb-2008
18:12
x86
Replsub.dll
2005.90.3228.0
408,088
09-Feb-2008
18:12
x86
Replsync.dll
2005.90.3228.0
101,400
09-Feb-2008
18:12
x86
Sac.exe
9.0.3228.0
82,968
09-Feb-2008
18:12
x86
Sqlaccess.dll
2005.90.3228.0
350,232
09-Feb-2008
18:12
x86
Sqladhlp90.exe
2005.90.3228.0
47,128
09-Feb-2008
18:12
x86
Sqlagent90.exe
2005.90.3228.0
349,720
09-Feb-2008
18:12
x86
Sqlbrowser.exe
2005.90.3228.0
242,712
09-Feb-2008
18:12
x86
Sqlcmd.exe
2005.90.3228.0
143,384
09-Feb-2008
18:12
x86
Sqlctr90.dll
2005.90.3228.0
67,608
09-Feb-2008
18:12
x86
Sqldiag.exe
2005.90.3228.0
1,074,200
09-Feb-2008
18:12
x86
Sqldumper.exe
2005.90.3228.0
68,632
09-Feb-2008
18:12
x86
Sqlmaint.exe
2005.90.3228.0
77,848
09-Feb-2008
18:12
x86
Sqlmergx.dll
2005.90.3228.0
194,072
09-Feb-2008
18:12
x86
Sqlmgmprovider.dll
2005.90.3228.0
236,568
09-Feb-2008
18:12
x86
Sqlsac.exe
2005.90.3228.0
1,246,232
09-Feb-2008
18:12
x86
Sqlservr.exe
2005.90.3228.0
29,216,280
09-Feb-2008
18:12
x86
Sqlsqm.exe
9.0.3228.0
128,024
09-Feb-2008
18:12
x86
Sqlwep.dll
2005.90.3228.0
90,648
09-Feb-2008
18:12
x86
Sqlwtsn.exe
9.0.3228.0
99,352
09-Feb-2008
18:12
x86
Sqsrvres.dll
2005.90.3228.0
70,168
09-Feb-2008
18:12
x86
Ssradd.dll
2005.90.3228.0
42,520
09-Feb-2008
18:12
x86
Ssravg.dll
2005.90.3228.0
43,032
09-Feb-2008
18:12
x86
Ssrmax.dll
2005.90.3228.0
40,984
09-Feb-2008
18:12
x86
Ssrmin.dll
2005.90.3228.0
40,984
09-Feb-2008
18:12
x86
Ssrpub.dll
2005.90.3228.0
30,232
09-Feb-2008
18:12
x86
Svrenumapi.dll
2005.90.3228.0
615,448
09-Feb-2008
18:12
x86
Tablediff.exe
9.0.3228.0
87,064
09-Feb-2008
18:12
x86
Thawbrkr.dll
12.0.7822.0
206,184
22-Jun-2007
9:22
x86
Xmlfilt.dll
12.0.7822.0
197,992
22-Jun-2007
9:22
x86
Xmlsub.dll
2005.90.3228.0
194,584
09-Feb-2008
18:12
x86
Xpadsi90.exe
2005.90.3228.0
50,712
09-Feb-2008
18:12
x86
Xpqueue.dll
2005.90.3228.0
56,856
09-Feb-2008
18:12
x86
Xprepl.dll
2005.90.3228.0
73,240
09-Feb-2008
18:12
x86
Xpstar90.dll
2005.90.3228.0
298,520
09-Feb-2008
18:12
x86
SQL Server 2005 Analysis Services, 32-bit version
File name
File version
File size
Date
Time
Platform
Microsoft.Analysisservices.dll
9.0.3228.0
1,217,560
09-Feb-2008
18:12
x86
Microsoft.Datawarehouse.dll
9.0.3228.0
1,279,000
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Connectioninfo.dll
9.0.3228.0
156,696
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Servicebrokerenum.dll
9.0.3228.0
42,008
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Smo.dll
9.0.3228.0
1,606,680
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Smoenum.dll
9.0.3228.0
222,232
09-Feb-2008
18:12
x86
Microsoft.Sqlserver.Sqlenum.dll
9.0.3228.0
898,072
09-Feb-2008
18:12
x86
Msadomdx.dll
9.0.3228.0
502,296
09-Feb-2008
18:12
x86
Msmdlocal.dll
9.0.3228.0
15,969,304
09-Feb-2008
18:12
x86
Msmdredir.dll
9.0.3228.0
4,022,808
09-Feb-2008
18:12
x86
Msmdspdm.dll
9.0.3228.0
201,752
09-Feb-2008
18:12
x86
Msmdsrv.exe
9.0.3228.0
14,936,600
09-Feb-2008
18:12
x86
Msmgdsrv.dll
9.0.3228.0
6,046,744
09-Feb-2008
18:12
x86
Msolap90.dll
9.0.3228.0
4,300,312
09-Feb-2008
18:12
x86
Sac.exe
9.0.3228.0
82,968
09-Feb-2008
18:12
x86
Sqlbrowser.exe
2005.90.3228.0
242,712
09-Feb-2008
18:12
x86
Sqldumper.exe
2005.90.3228.0
68,632
09-Feb-2008
18:12
x86
Sqlmgmprovider.dll
2005.90.3228.0
236,568
09-Feb-2008
18:12
x86
Sqlsac.exe
2005.90.3228.0
1,246,232
09-Feb-2008
18:12
x86
Sqlsqm.exe
9.0.3228.0
128,024
09-Feb-2008
18:12
x86
Sqlwtsn.exe
9.0.3228.0
99,352
09-Feb-2008
18:12
x86
Svrenumapi.dll
2005.90.3228.0
615,448
09-Feb-2008
18:12
x86
SQL Server 2005 Reporting Services, 32-bit version