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 8 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 3257.
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).
How to obtain Cumulative Update 8 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.
Note Cumulative Update 8 for SQL Server 2005 Service Pack 2 does not contain the update for SQL Native Client. A stand-alone package of SQL Native Client is released together with Cumulative Update 8.
FIX: A data source view that connects to an Oracle database generates incorrect relationships when you develop a Microsoft SQL Server 2005 Analysis Services project by using BIDS
50002572
FIX: Error message when you run an MDX query after you synchronize a SQL Server 2005 Analysis Services database between two instances: "Current session is no longer valid due to structural changes in the database"
FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server 2005 Reporting Services report
50002658
FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005
FIX: The transactional replication does not run the corresponding stored procedure at the subscriber when the stored procedure is run at the publisher in SQL Server 2005
FIX: A time series prediction query takes a long time to run in SQL Server 2005 Analysis Services
50002676
An infinite recursion occurs in the CalculationPassValue function in SQL Server 2005 Analysis Services
50002692
In SQL Server 2005, subscriptions expire prematurely because the value of the genstatus column for the subscriptions is 4 in the Msmerge_genhistory table
FIX: E-mail replies are sent to the sender address instead of to the address that is specified in the database mail profile in SQL Server 2005 after you install the .NET Framework 2.0 Service Pack 1
50002727
Join filters in a merge replication do not replicate the rows that match the join filter clause to the partition after an update operation is performed on the rows in SQL Server 2005
FIX: An access violation occurs when you run two DMX queries against the same time series mining model at the same time in SQL Server 2005 Analysis Services
50002735
If a parent table of a join filter is updated on multiple rows, the rows that are inserted into the related table are not replicated to the partition in a merge replication of SQL Server 2005
FIX: CPU utilization is high when you run a trace that contains a text filter in SQL Server 2005
50002773
An access violation occurs in a PFString object because the sm_mskDefaultSettings mask for the PFString object is incorrect in SQL Server 2005 Analysis Services
50002786
During a merge replication in SQL Server 2005, the sp_Msmakegeneration stored procedure may always run
FIX: Error message when you use the bcp utility to run the sp_send_dbmail stored procedure in SQL Server 2005 Service Pack 2 Cumulative Update 5: "Error = [Microsoft][SQL Native Client]Function sequence error"
FIX: Error message when you call a table valued function that uses a common language runtime (CLR) assembly in SQL Server 2005: "AppDomain <ApplicationDomain> is marked for unload due to memory pressure"
FIX: Error message when you run an UPDATE CUBE statement against a write-enabled cube in SQL Server 2005 Analysis Services: "Errors in the high-level relational engine"
FIX: All the MDX queries that are running on an instance of SQL Server 2005 Analysis Services are canceled when you start or stop a SQL Server Profiler trace for the instance
50002854
When two threads call the sp_Msallocate_new_identity_range stored procedure at the same time in a merge replication, INSERT operations cannot be performed on the publisher in SQL Server 2005
50002862
If you perform many DELETE operations and many INSERT operations on a database that has the READ_COMMITTED_SNAPSHOT database option set to ON, the size of the database increases greatly
FIX: The compilation time of some queries is very long in an x64-based version of SQL Server 2005
50002865
Error message when you delete a row from a table that has a nonclustered primary key if the table is referenced by a foreign key of another table that uses the ON DELETE SET option: "Internal Query Processor Error: The query processor could not produce a query plan"
50002876
FIX: An access violation occurs when you run an XMLA query in SQL Server 2005 Analysis Services
FIX: When you connect to an instance of SQL Server 2005 by using the SQL Native Client ODBC driver, the SQL_PARAM_IGNORE setting has no effect
Note This issue is fixed in the stand-alone package of SQL Native Client that is released together with Cumulative Update 8.
50002804 50002784
<TrustInfo> tags are add to the manifest file (MT_ADDITIONALMANIFEST) for the bcp utility. The <TrustInfo> tags require independent software vendors to obtain logo certification for applications that use SQL Server Express Edition
Note This issue is fixed in the stand-alone package of SQL Native Client that is released together with Cumulative Update 8.
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.
File information for Cumulative Update 8
Note Cumulative Update 8 for SQL Server 2005 Service Pack 2 does not contain the update for SQL Native Client.
SQL Server 2005 Database Engine, 32-bit version
File name
File version
File size
Date
Time
Platform
Bcp.exe
2005.90.3257.0
68,632
13-Jun-2008
1:07
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
Databasemailengine.dll
9.0.3257.0
78,872
13-Jun-2008
1:07
x86
Databasemailprotocols.dll
9.0.3257.0
46,104
13-Jun-2008
1:07
x86
Distrib.exe
2005.90.3257.0
70,680
13-Jun-2008
1:07
x86
Dts.dll
2005.90.3257.0
1,102,360
13-Jun-2008
1:07
x86
Dtsconn.dll
2005.90.3257.0
250,392
13-Jun-2008
1:07
x86
Dtspipeline.dll
2005.90.3257.0
605,208
13-Jun-2008
1:07
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
Logread.exe
2005.90.3257.0
400,408
13-Jun-2008
1:07
x86
Mergetxt.dll
2005.90.3257.0
32,280
13-Jun-2008
1:07
x86
Microsoft.analysisservices.dll
9.0.3257.0
1,217,560
13-Jun-2008
1:07
x86
Microsoft.sqlserver.connectioninfo.dll
9.0.3257.0
156,696
13-Jun-2008
1:07
x86
Microsoft.sqlserver.dtstransferprovider.dll
9.0.3257.0
115,736
13-Jun-2008
1:07
x86
Microsoft.sqlserver.maintenanceplantasks.dll
9.0.3257.0
295,960
13-Jun-2008
1:07
x86
Microsoft.sqlserver.replication.dll
2005.90.3257.0
1,628,184
13-Jun-2008
1:07
x86
Microsoft.sqlserver.servicebrokerenum.dll
9.0.3257.0
42,008
13-Jun-2008
1:07
x86
Microsoft.sqlserver.smo.dll
9.0.3257.0
1,606,680
13-Jun-2008
1:07
x86
Microsoft.sqlserver.smoenum.dll
9.0.3257.0
222,232
13-Jun-2008
1:07
x86
Microsoft.sqlserver.sqlenum.dll
9.0.3257.0
898,072
13-Jun-2008
1:07
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.3257.0
200,216
13-Jun-2008
1:07
x86
Msir5jp.dll
5.0.2130.0
3,159,912
22-Jun-2007
9:22
x86
Msmdlocal.dll
9.0.3257.0
15,970,328
13-Jun-2008
1:07
x86
Msmdredir.dll
9.0.3257.0
4,022,808
13-Jun-2008
1:07
x86
Msxmlsql.dll
2005.90.3257.0
869,912
13-Jun-2008
1:07
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.3257.0
58,904
13-Jun-2008
1:07
x86
Osql.exe
2005.90.3257.0
53,784
13-Jun-2008
1:07
x86
Query.dll
12.0.7822.0
48,488
22-Jun-2007
9:22
x86
Rdistcom.dll
2005.90.3257.0
644,632
13-Jun-2008
1:07
x86
Repldp.dll
2005.90.3257.0
186,904
13-Jun-2008
1:07
x86
Replerrx.dll
2005.90.3257.0
114,712
13-Jun-2008
1:07
x86
Replisapi.dll
2005.90.3257.0
272,920
13-Jun-2008
1:07
x86
Replmerg.exe
2005.90.3257.0
321,048
13-Jun-2008
1:07
x86
Replprov.dll
2005.90.3257.0
554,520
13-Jun-2008
1:07
x86
Replrec.dll
2005.90.3257.0
786,968
13-Jun-2008
1:07
x86
Replsub.dll
2005.90.3257.0
408,088
13-Jun-2008
1:07
x86
Replsync.dll
2005.90.3257.0
101,400
13-Jun-2008
1:07
x86
Sac.exe
2005.90.3257.0
82,968
13-Jun-2008
1:07
x86
Sqlaccess.dll
2005.90.3257.0
350,232
13-Jun-2008
1:07
x86
Sqladhlp90.exe
2005.90.3257.0
47,640
13-Jun-2008
1:07
x86
Sqlagent90.exe
2005.90.3257.0
349,720
13-Jun-2008
1:07
x86
Sqlbrowser.exe
2005.90.3257.0
242,712
13-Jun-2008
1:07
x86
Sqlcmd.exe
2005.90.3257.0
143,896
13-Jun-2008
1:07
x86
Sqlctr90.dll
2005.90.3257.0
67,608
13-Jun-2008
1:07
x86
Sqldiag.exe
2005.90.3257.0
1,074,712
13-Jun-2008
1:07
x86
Sqldumper.exe
2005.90.3257.0
68,632
13-Jun-2008
1:07
x86
Sqlmaint.exe
2005.90.3257.0
78,360
13-Jun-2008
1:07
x86
Sqlmergx.dll
2005.90.3257.0
194,072
13-Jun-2008
1:07
x86
Sqlmgmprovider.dll
2005.90.3257.0
236,568
13-Jun-2008
1:07
x86
Sqlsac.exe
2005.90.3257.0
1,246,232
13-Jun-2008
1:07
x86
Sqlservr.exe
2005.90.3257.0
29,224,472
13-Jun-2008
1:07
x86
Sqlsqm.exe
2005.90.3257.0
140,312
13-Jun-2008
1:07
x86
Sqlwep.dll
2005.90.3257.0
90,648
13-Jun-2008
1:07
x86
Sqlwtsn.exe
9.0.3257.0
99,352
13-Jun-2008
1:07
x86
Sqsrvres.dll
2005.90.3257.0
70,168
13-Jun-2008
1:07
x86
Ssradd.dll
2005.90.3257.0
42,520
13-Jun-2008
1:07
x86
Ssravg.dll
2005.90.3257.0
43,032
13-Jun-2008
1:07
x86
Ssrmax.dll
2005.90.3257.0
40,984
13-Jun-2008
1:07
x86
Ssrmin.dll
2005.90.3257.0
40,984
13-Jun-2008
1:07
x86
Ssrpub.dll
2005.90.3257.0
30,232
13-Jun-2008
1:07
x86
Svrenumapi.dll
2005.90.3257.0
614,936
13-Jun-2008
1:07
x86
Tablediff.exe
2005.90.3257.0
87,064
13-Jun-2008
1:07
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.3257.0
194,584
13-Jun-2008
1:07
x86
Xpadsi90.exe
2005.90.3257.0
51,224
13-Jun-2008
1:07
x86
Xpqueue.dll
2005.90.3257.0
56,856
13-Jun-2008
1:07
x86
Xprepl.dll
2005.90.3257.0
73,240
13-Jun-2008
1:07
x86
Xpstar90.dll
2005.90.3257.0
298,520
13-Jun-2008
1:07
x86
SQL Server 2005 Analysis Services, 32-bit version
File name
File version
File size
Date
Time
Platform
Microsoft.analysisservices.dll
9.0.3257.0
1,217,560
13-Jun-2008
1:07
x86
Microsoft.datawarehouse.dll
9.0.3257.0
1,279,000
13-Jun-2008
1:07
x86
Microsoft.sqlserver.connectioninfo.dll
9.0.3257.0
156,696
13-Jun-2008
1:07
x86
Microsoft.sqlserver.servicebrokerenum.dll
9.0.3257.0
42,008
13-Jun-2008
1:07
x86
Microsoft.sqlserver.smo.dll
9.0.3257.0
1,606,680
13-Jun-2008
1:07
x86
Microsoft.sqlserver.smoenum.dll
9.0.3257.0
222,232
13-Jun-2008
1:07
x86
Microsoft.sqlserver.sqlenum.dll
9.0.3257.0
898,072
13-Jun-2008
1:07
x86
Msadomdx.dll
9.0.3257.0
502,296
13-Jun-2008
1:07
x86
Msmdlocal.dll
9.0.3257.0
15,970,328
13-Jun-2008
1:07
x86
Msmdredir.dll
9.0.3257.0
4,022,808
13-Jun-2008
1:07
x86
Msmdspdm.dll
9.0.3257.0
201,752
13-Jun-2008
1:07
x86
Msmdsrv.exe
9.0.3257.0
14,937,624
13-Jun-2008
1:07
x86
Msmgdsrv.dll
9.0.3257.0
6,046,232
13-Jun-2008
1:07
x86
Msolap90.dll
9.0.3257.0
4,300,312
13-Jun-2008
1:07
x86
Sac.exe
2005.90.3257.0
82,968
13-Jun-2008
1:07
x86
Sqlbrowser.exe
2005.90.3257.0
242,712
13-Jun-2008
1:07
x86
Sqldumper.exe
2005.90.3257.0
68,632
13-Jun-2008
1:07
x86
Sqlmgmprovider.dll
2005.90.3257.0
236,568
13-Jun-2008
1:07
x86
Sqlsac.exe
2005.90.3257.0
1,246,232
13-Jun-2008
1:07
x86
Sqlsqm.exe
2005.90.3257.0
140,312
13-Jun-2008
1:07
x86
Sqlwtsn.exe
9.0.3257.0
99,352
13-Jun-2008
1:07
x86
Svrenumapi.dll
2005.90.3257.0
614,936
13-Jun-2008
1:07
x86
SQL Server 2005 Reporting Services, 32-bit version
Help and Support
Back to the top