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 4 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 3200.
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 4 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 run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services: "Internal error An unexpected exception occured"
FIX: The SQL Native Client OLE DB provider (SQLNCLI) leaks memory when you call the IRowsetFastLoad::Commit method in a SQL Server 2005-based application
FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner"
FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005
FIX: Error message when you run the CREATE ASSEMBLY statement to register a CLR assembly in SQL Server 2005: "An error occurred while gathering metadata from assembly '<AssemblyName>' with HRESULT 0x80131"
Error message in the SQL Server Errorlog file when you create and delete stored procedures concurrently in SQL Server 2005: "Error: 701: There is insufficient system memory to run this query"
FIX: Error message when you set up a snapshot publication on a database in SQL Server 2005: "Error 137, Must declare the scalar variable <VariableName>"
FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005
FIX: Error message when you run the BULK INSERT statement in Microsoft SQL Server 2005: "The bulk load failed. The column is too long in the data file for row <n>, column <n>"
FIX: After you enable the Address Windowing Extensions (AWE) feature in SQL Server 2005, access violations may occur, and SQL Server 2005 may stop responding
FIX: Error message when you process the index for a partition in a cube in SQL Server 2005 Analysis Services: “Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3311, function 'PFFileStore::HandleDataPageFault')”
FIX: Error message when you try to build or to deploy a report server project of SQL Server 2005 Reporting Services: "This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms"
FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the same packages by using the Dtexec.exe utility
FIX: Error message when you synchronize a merge replication in a replication topology that contains two or more re-publishers in SQL Server 2005: "21997 Failed to allocate new identity range"
FIX: The Analysis Services service stops unexpectedly when you run a Multidimensional Expressions query that uses unary operators on a dimension in SQL Server 2005 Analysis Services
FIX: You receive a time-out error message when you try to send a message to the target service of a Service Broker application that you create in SQL Server 2005
FIX: The W3WP.exe process of Internet Information Services stops unexpectedly when you configure a merge replication that uses Web synchronization in SQL Server 2005
FIX: Error message when you use the "bcp_sendrow" function in a SQL Server 2005-based application that uses a SQL Native Client provider: "For BCP, all variable-length data must have either a length-prefix or a terminator specified"
FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005
FIX: The content of a group is displayed incorrectly when you change a parameter and then you click a toggle image in SQL Server 2005 Reporting Services
FIX: An access violation may occur intermittently in the DTSPipeline.dll file when you run an Integration Services package that contains a Data Flow task in SQL Server 2005
FIX: Error message when you run the DBCC CHECKTABLE statement or the DBCC CHECKDB statement in Microsoft SQL Server 2005: "Column '<ColumnName>' value is out of range for data type 'float'"
FIX: Error message when you run a DML statement against a table in a SQL Server 2005 Integration Services package: "Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0"
FIX: When you run a stored procedure that uses some views in SQL Server 2005, the performance is slow compared to SQL Server 2000 if the views use the JOIN operator and contain subqueries
After you install Cumulative Update Package 4 for SQL Server 2005 SP2, time stamp information that is related to the RSPrintClient ActiveX control is logged in the report server log file
FIX: A query that has many outer joins takes a long time to compile in SQL Server 2005
50001800
A race condition occurs when you stop the SQL Browser service
50001836
The GetSPItemMetaDataAndContent function resets stack location in SQL Server 2005 Reporting Services
50001661
Applications do not connect to the failover partner after the initial partner is attached to a debugger.
50001672
A random access violation occurs in Service Broker threads. This random access violation causes SQL Server to exit.
50001702
After you upgrade SQL Server 2005 Analysis Services from Service Pack 1 to Service Pack 2, the query performance is slow because the number of the Calculate Non Empty Current event class greatly increases.
50001710
After you upgrade SQL Server 2005 Analysis Services from Service Pack 1 to Service Pack 2, the performance of a Serialize Result Current event class is 20 times slower than in Service Pack 1.
50001712
In SQL Server 2005 Reporting Services, if a report server runs in SharePoint integrated mode, users who request a report from the SharePoint Web site receive a "401 Unauthorized" error message after you switch a Windows SharePoint Services Web site or a Microsoft Office SharePoint Portal Server Web site to use basic authentication.
50001742
In SQL Server 2005 Analysis Services Service Pack 2, frequent access violations occur in the "PFCompressIterator::DecompressArray" function under stress conditions.
50001782
You cannot configure the security settings for database dimensions when the database name is the same as the cube name.
50001816
When you export a SQL Server 2005 Reporting Services report to a .pdf file, blank pages are added.
50001888
The SQL Server 2005 database engine incorrectly checks permissions for the KILL command.
50001750
SQL Server Management Objects (SMO) are updated in the Cumulative Update (CU) branch for SQL Server 2005 Service Pack 2 for handoff to the developer division.
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.3200.0
68,624
02-Oct-2007
21:09
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.3200.0
46,096
02-Oct-2007
21:09
x86
Dts.Dll
2005.90.3200.0
1,102,352
02-Oct-2007
21:09
x86
Dtsconn.Dll
2005.90.3200.0
250,384
02-Oct-2007
21:09
x86
Dtspipeline.Dll
2005.90.3200.0
605,200
02-Oct-2007
21:09
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
Microsoft.Analysisservices.Dll
9.0.3200.0
1,217,552
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Connectioninfo.Dll
9.0.3200.0
156,688
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Dtstransferprovider.Dll
9.0.3200.0
115,728
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Maintenanceplantasks.Dll
9.0.3200.0
295,952
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Replication.Dll
2005.90.3200.0
1,627,152
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Servicebrokerenum.Dll
9.0.3200.0
42,000
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Smo.Dll
9.0.3200.0
1,606,672
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Smoenum.Dll
9.0.3200.0
222,224
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Sqlenum.Dll
9.0.3200.0
898,064
02-Oct-2007
21:09
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
Msir5Jp.Dll
5.0.2130.0
3,159,912
22-Jun-2007
9:22
x86
Msmdlocal.Dll
9.0.3200.0
15,954,960
02-Oct-2007
21:09
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.3200.0
58,896
02-Oct-2007
21:09
x86
Query.Dll
12.0.7822.0
48,488
22-Jun-2007
9:22
x86
Rdistcom.Dll
2005.90.3200.0
644,624
02-Oct-2007
21:09
x86
Replmerg.Exe
2005.90.3200.0
320,528
02-Oct-2007
21:09
x86
Replprov.Dll
2005.90.3200.0
549,904
02-Oct-2007
21:09
x86
Replrec.Dll
2005.90.3200.0
784,912
02-Oct-2007
21:09
x86
Sqlaccess.Dll
2005.90.3200.0
350,224
02-Oct-2007
21:09
x86
Sqlagent90.Exe
2005.90.3200.0
349,200
02-Oct-2007
21:09
x86
Sqlbrowser.Exe
2005.90.3200.0
242,704
02-Oct-2007
21:09
x86
Sqlservr.Exe
2005.90.3200.0
29,209,616
02-Oct-2007
21:09
x86
Sqlwep.Dll
2005.90.3200.0
90,640
02-Oct-2007
21:09
x86
Sqsrvres.Dll
2005.90.3200.0
70,160
02-Oct-2007
21:09
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
Xpstar90.Dll
2005.90.3200.0
298,512
02-Oct-2007
21:09
x86
SQL Server 2005 Analysis Services, 32-bit version
File name
File version
File size
Date
Time
Platform
Microsoft.Analysisservices.Dll
9.0.3200.0
1,217,552
02-Oct-2007
21:09
x86
Microsoft.Datawarehouse.Dll
9.0.3200.0
1,278,992
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Connectioninfo.Dll
9.0.3200.0
156,688
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Servicebrokerenum.Dll
9.0.3200.0
42,000
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Smo.Dll
9.0.3200.0
1,606,672
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Smoenum.Dll
9.0.3200.0
222,224
02-Oct-2007
21:09
x86
Microsoft.Sqlserver.Sqlenum.Dll
9.0.3200.0
898,064
02-Oct-2007
21:09
x86
Msadomdx.Dll
9.0.3200.0
502,288
02-Oct-2007
21:09
x86
Msmdlocal.Dll
9.0.3200.0
15,954,960
02-Oct-2007
21:09
x86
Msmdspdm.Dll
9.0.3200.0
201,744
02-Oct-2007
21:09
x86
Msmdsrv.Exe
9.0.3200.0
14,923,792
02-Oct-2007
21:09
x86
Msmgdsrv.Dll
9.0.3200.0
6,045,200
02-Oct-2007
21:09
x86
Msolap90.Dll
9.0.3200.0
4,298,768
02-Oct-2007
21:09
x86
Sqlbrowser.Exe
2005.90.3200.0
242,704
02-Oct-2007
21:09
x86
SQL Server 2005 Reporting Services, 32-bit version
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:
937137 (http://support.microsoft.com/kb/937137/LN/) 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:
935897 (http://support.microsoft.com/kb/935897/LN/) 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:
913089 (http://support.microsoft.com/kb/913089/LN/) How to obtain the latest service pack for SQL Server 2005
For more information about the new features and the improvements in SQL Server 2005 Service Pack 2, visit the following Microsoft Web site:
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:
822499 (http://support.microsoft.com/kb/822499/LN/) New naming schema for Microsoft SQL Server software update packages
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 (http://support.microsoft.com/kb/824684/LN/) Description of the standard terminology that is used to describe Microsoft software updates
Need More Help? Contact a Support professional by Email, Online or Phone.
Customer Service For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
Newsgroups Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.