System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
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 2 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 3175.
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. There is only one cumulative update package for all languages.
One cumulative update 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 install the cumulative update package. For more information about the SMO and DMO XPs option, see the 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 2 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.
SQL Server 2005 post-SP2 hotfixes that are included in cumulative update package 2 for SQL Server 2005 SP2
Note Microsoft Knowledge Base articles that discuss these hotfixes will be released as the hotfixes become available. For more information about each bug, click the article number to view the article in the Microsoft Knowledge Base.
Collapse this tableExpand this table
SQL hotfix bug number
Knowledge Base article number
Description
50000927
FIX: Partitions that has the proactive caching feature enabled may return values that exceed the values in the data source in SQL Server 2005 Analysis Services
FIX: You receive incorrect results when you run an MDX query against a dimension that contains a parent-child hierarchy in SQL Server 2005 Analysis Services
FIX: You experience problems when you use SQL Server Business Intelligence Development Studio to create an SSIS package after you install SQL Server 2005 Service Pack 2
FIX: When you run an MDX query for the second time, the query does not run faster than the first time that you ran the query in SQL Server 2005 Analysis Services
FIX: The operation takes a long time to be completed when you process a partition that has proactive caching enabled in SQL Server 2005 Analysis Services
FIX: Error message when you try to build a mining model that contains lots of data on a 32-bit SQL Server 2005 Analysis Services server: "Memory error: Allocation failure: Not enough storage is available to the process command"
FIX: Error message when you run an MDX query that retrieves data from an Analysis Services database: "An error occurred while the dimension, with the ID of '<DatabaseName>', Name of '<DimensionName>' was being processed"
FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileStore::HandleDataPageFault')"
FIX: Error message when you run a DMX query that uses a linked server to query data from a Microsoft SQL Server 2005 Analysis Services server: "The following system error occurred: Logon failure: unknown user name or bad password"
A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2
50001042
A System.FormatException exception occurs in a .NET Framework 2.0 application when you use the ADOMD.NET data provider to retrieve numeric data from SQL Server 2005 Analysis Services
50001096
An exception occurs when you open the query builder in SQL Server 2005 Reporting Services on a computer that is running a Spanish version of Microsoft Windows
50001054
After you install SQL Server 2005 Service Pack 2, the granularity of subcube requests appears to be at the key attribute of parent/child dimensions, and you experience slow performance when you query the parent/child dimension in SQL Server 2005 Analysis Services
FIX: You obtain an incorrect prediction when you browse a mining structure that is created by using the Microsoft Association algorithm in SQL Server 2005 Analysis Services
FIX: You may receive incorrect results when you run a Multidimensional Expressions (MDX) query and the WHERE clause and the SELECT clause in the query contain different attributes of the same dimension in SQL Server 2005 Analysis Services
FIX: You cannot obtain statements in the current batch in SQL Server 2005 by using the DBCC INPUTBUFFER statement, trace flag 1204, deadlock graph event class, or Activity Monitor
FIX: The row of data on the publisher and the row of data on the subscriber may be inconsistent in a merge publication after synchronization has occurred in SQL Server 2005
FIX: Some values of measures in a cube unexpectedly appear as "#N/A" when you enable the "Enable read-contingent permissions" option for the cube in SQL Server 2005 Analysis Services Service Pack 2
FIX: Error message when you use the Association Rules algorithm to process a data mining model in SQL Server 2005 Analysis Services: "This number of attributes exceeds the attribute limit of 5000 allowed by the current version of the algorithm"
FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: "The operating system returned error 5(Access is denied.) to SQL Server"
FIX: Error message when you run a maintenance plan that contains a Back Up Database task in Microsoft SQL Server 2005 Service Pack 2: "0x80004003: Object reference not set to an instance of an object"
FIX: Error message when you install Microsoft Dynamics CRM:"Setup failed to validate specified Reporting Services Report Server" or "Setup requires SQL Server Reporting Services 2005 Hotfix for role creation on SQL Reporting Service SP2 Workgroup edition"
FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: "The merge process failed to execute a query because the query timed out"
FIX: You obtain inconsistent results when you run an MDX query that uses the Siblings function against an instance of SQL Server 2005 Analysis Services compared to an instance of SQL Server 2000 Analysis Services
FIX: The Report Designer or the Report Manager stops responding when you try to export a SQL Server 2005 Reporting Services report to a PDF file or a TIFF file
FIX: The client application stops responding, and the Msmdsrv.exe process uses all the available memory after you perform the filtering operation and the browsing operation against an instance of SQL Server 2005 Analysis Services
FIX: Event ID: 21421 occurs when you use the Microsoft Operations Manager 2005 agent to monitor a clustered instance of SQL Server 2005 in a clustered environment
FIX: Error messages when you run a query that references a view in SQL Server 2005 Service Pack 2: "A severe error occurred on the current command. The results, if any, should be discarded"
FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name used in the query"
FIX: Error messages are logged, and some threads may not sort the data successfully if many threads are displaying a report in SQL Server 2005 Reporting Services
50001212
FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup of a database that is larger than 2 terabytes: "Unable to obtain required information about the server"
FIX: Error message when you run a SQL Server 2005 Integration Services (SSIS) package that contains a Fuzzy Lookup transformation: "System.Data.SqlClient.SqlException Error number 8101 is invalid"
FIX: Error message when you run a linked server query in SQL Server 2005: "The oledbprovider unisys.dmsII.1 for linkserver '<ServerName>' reported an error the provider ran out of memory"
FIX: Error message when you connect to an instance of SQL Server 2005 Analysis Services after you cancel an MDX query that has been running for a long time: "A connection attempt failed because the connected party did not properly respond"
FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in SQL Server 2005: "Must declare the scalar variable "@Variable""
FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005
FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication
A memory leak may occur when the Merge Replication Agent retries a connection in SQL Server 2005
50001259
Error message when you use the SQL Server Native Client to bulk insert data into a column of a large object data type in SQL Server 2005: "Conversions not allowed using bcp_moretext"
FIX: You cannot select the child parameters even after you select the parent parameter when you use the Report Viewer Web part on a SharePoint site to view a SQL Server 2005 Reporting Services report
FIX: You cannot bring the SQL Server group online in a cluster environment after you rename the virtual server name of the default instance of SQL Server 2005
FIX: The update may take a longer time to complete in SQL Server 2005 than in SQL Server 2000 when you update subscribers of a transactional publication that has immediate updating subscriptions enabled
FIX: In a maintenance plan, the databases that you selected are no longer selected when you edit a Back Up Database task in SQL Server 2005 Service Pack 2
FIX: Error message when you run a query that references a temporary table in SQL Server 2005: "Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption"
FIX: Dates in the Datetimepicker control appear in the incorrect format when you view a report of SQL Server 2005 Reporting Services with SP2 on a server that is set to a German locale
FIX: Additional data columns for ascendant members are returned unexpectedly when you run an MDX statement against an instance of SQL Server 2005 Analysis Services that has SQL Server 2005 Service Pack 2 installed
FIX: A memory leak occurs when you use the sp_OAMethod stored procedure or the sp_OAGetProperty stored procedure to call a method of a COM object in SQL Server 2005
FIX: You receive an access violation when you process an object or alter an object after you run an MDX query against the object in Microsoft SQL Server 2005 Analysis Services
FIX: The estimate of the number of children that a dimension member has may be inaccurate when you request the CHILDREN_CARDINALITY property for a dimension member in SQL Server 2005 Analysis Services
FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP1: "The OLE DB provider "BULK" for linked server "(null)" reported an error"
FIX: Error message when you try to synchronize a SQL Server 2005 Compact Edition subscription again: "The common generation watermark is invalid at this replica since it does not exist"
FIX: Error message when you import data from a flat file in a SQL Server 2005 Integration Services (SSIS) package: "There is a partial row at the end of the file"
FIX: An SSIS package stops responding when you run the package and the package contains a data flow task that contains one or more MergeJoin transformations in SQL Server 2005
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/
)
How to obtain the latest service pack for SQL Server 2005
Restart information
The SQL Server service must be restarted. The Setup program restarts the SQL Server service. You may also have to restart the computer.
Registry information
You do not have to change the registry.
File information
This cumulative update package contains only those files that are required to correct the issues that this article lists. This cumulative update package may not contain all the files that you must have to fully update a product to the latest build.
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
Microsoft.analysisservices.dll
9.0.3175.0
1,217,904
14-Jun-2007
15:05
x86
Microsoft.sqlserver.maintenanceplantasks.dll
9.0.3175.0
296,304
14-Jun-2007
15:05
x86
Msmdlocal.dll
9.0.3175.0
15,948,144
14-Jun-2007
15:05
x86
Mssqlsystemresource.ldf
Not applicable
524,288
14-Jun-2007
11:22
Not applicable
Mssqlsystemresource.mdf
Not applicable
40,173,568
14-Jun-2007
11:22
Not applicable
Odsole70.dll
2005.90.3175.0
59,248
14-Jun-2007
15:05
x86
Rdistcom.dll
2005.90.3175.0
644,976
14-Jun-2007
15:05
x86
Replmerg.exe
2005.90.3175.0
320,880
14-Jun-2007
15:05
x86
Replrec.dll
2005.90.3175.0
784,752
14-Jun-2007
15:05
x86
Sqlaccess.dll
2005.90.3175.0
350,576
14-Jun-2007
15:05
x86
Sqlservr.exe
2005.90.3175.0
29,193,072
14-Jun-2007
15:05
x86
Sqlwep.dll
2005.90.3175.0
90,992
14-Jun-2007
15:05
x86
Sqsrvres.dll
2005.90.3175.0
70,512
14-Jun-2007
15:05
x86
Sysdbupg.sql
Not applicable
510,622
13-Jun-2007
20:46
Not applicable
Xpstar90.dll
2005.90.3175.0
295,792
14-Jun-2007
15:05
x86
SQL Server 2005 Analysis Services, 32-bit version
Collapse this tableExpand this table
File name
File version
File size
Date
Time
Platform
As80.xsl
Not applicable
16,801
13-Jun-2007
19:46
Not applicable
As80.xsl
Not applicable
16,801
13-Jun-2007
20:46
Not applicable
As90.xsl
Not applicable
18,291
13-Jun-2007
19:46
Not applicable
As90.xsl
Not applicable
18,291
13-Jun-2007
20:46
Not applicable
Db2v0801.xsl
Not applicable
29,497
13-Jun-2007
20:46
Not applicable
Microsoft.analysisservices.dll
9.0.3175.0
1,217,904
14-Jun-2007
15:05
x86
Microsoft.datawarehouse.dll
9.0.3175.0
1,279,344
14-Jun-2007
15:05
x86
Msadomdx.dll
9.0.3175.0
502,640
14-Jun-2007
15:05
x86
Msjet.xsl
Not applicable
28,519
13-Jun-2007
19:46
Not applicable
Msjet.xsl
Not applicable
28,519
13-Jun-2007
20:46
Not applicable
Msmdlocal.dll
9.0.3175.0
15,948,144
14-Jun-2007
14:05
x86
Msmdlocal.dll
9.0.3175.0
15,948,144
14-Jun-2007
15:05
x86
Msmdspdm.dll
9.0.3175.0
202,096
14-Jun-2007
15:05
x86
Msmdsrv.exe
9.0.3175.0
14,916,464
14-Jun-2007
15:05
x86
Msmgdsrv.dll
9.0.3175.0
6,045,552
14-Jun-2007
14:05
x86
Msmgdsrv.dll
9.0.3175.0
6,045,552
14-Jun-2007
15:05
x86
Msolap90.dll
9.0.3175.0
4,299,120
14-Jun-2007
14:05
x86
Orcl7.xsl
Not applicable
32,058
13-Jun-2007
20:46
Not applicable
Sql2000.xsl
Not applicable
33,621
13-Jun-2007
19:46
Not applicable
Sql2000.xsl
Not applicable
33,621
13-Jun-2007
20:46
Not applicable
Sql70.xsl
Not applicable
31,699
13-Jun-2007
19:46
Not applicable
Sql70.xsl
Not applicable
31,699
13-Jun-2007
20:46
Not applicable
Sql90.xsl
Not applicable
38,953
13-Jun-2007
19:46
Not applicable
Sql90.xsl
Not applicable
38,953
13-Jun-2007
20:46
Not applicable
Trdtv2r41.xsl
Not applicable
26,914
13-Jun-2007
20:46
Not applicable
SQL Server 2005 Reporting Services, 32-bit version
For more information about the list of builds that are available after SQL Server 2005 Service Pack 2 was released, 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
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/
)
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/
)
How to obtain the latest service pack for SQL Server 2005
For more information about the new features in SQL Server 2005 SP2 and about the improvements in SQL Server 2005 SP2, 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/
)
New naming schema for Microsoft SQL Server software update packages