INTRODUCTION

Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 1 (SP1) hotfix to an installation of SQL Server 2005 SP1. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack. SQL Server 2005 SP1 includes all SQL Server 2005 hotfixes up to and including build 9.0.1530. For more information about which SQL Server 2005 hotfixes are included in SQL Server 2005 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

913090 A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1 Cumulative hotfix package (build 2153) for SQL Server 2005 contains SQL Server 2005 hotfixes that were not included in SQL Server 2005 SP1. This build roughly corresponds to SQL Server 2005 builds 9.0.1531 through build 9.0.1540. Note This hotfix rollup build is also known as build 2153.

Important notes about the cumulative hotfix package

  • SQL Server 2005 hotfixes are now multilanguage. There is only one cumulative hotfix package for all languages.

  • You must install each component package for your operating system.

  • You must enable the SQL Server Management Object (SMO) and SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you install the hotfix package. For more information about the SMO/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).

  • You must install all component packages in the order in which they are listed in this article. If you do not install the component packages in the correct order, you may receive an error message.For more information, click the following article number to view the article in the Microsoft Knowledge Base:

    919224 FIX: You may receive an error message when you install the cumulative hotfix package (build 2153) for SQL Server 2005

  • To uninstall this hotfix, follow these steps:

    1. Click Start, click Control Panel, and then click Add or Remove programs.

    2. In the Add or Remove Programs window, click the Add or Remove Programs icon.

    3. To see the rollup that is listed under your Microsoft SQL Server 2005 installation, select the Show Updates check box.

    4. You must uninstall the component packages in the order in which they are listed in this article.

More Information

How to obtain the cumulative hotfix package for SQL Server 2005 (build 9.0.2153)

Component packages for x86-based operating systems

If you are running SQL Server 2005 on an x86-based operating system, you must install the following component packages in the order in which they are presented:

SQL Server 2005http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-x86-ENU.exeMicrosoft SQL Server 2005 Analysis Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-x86-ENU.exeMicrosoft SQL Server 2005 Integration Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-x86-ENU.exeMicrosoft SQL Server 2005 Notification Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-x86-ENU.exeMicrosoft SQL Server 2005 Reporting Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-x86-ENU.exe SQL Server 2005 Toolshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-x86-ENU.exe

Component packages for x64-based operating systems

If you are running SQL Server 2005 on an x64-based operating system, you must install the following component packages in the order in which they are presented:

SQL Server 2005http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-x64-ENU.exeSQL Server 2005 Analysis Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-x64-ENU.exeSQL Server 2005 Integration Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-x64-ENU.exeSQL Server 2005 Notification Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-x64-ENU.exeSQL Server 2005 Reporting Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-x64-ENU.exeSQL Server 2005 Toolshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-x64-ENU.exe

Component packages for Itanium-based operating systems

If you are running SQL Server 2005 on an Itanium-based operating system, you must install the following component packages in the order in which they are presented:

SQL Server 2005 http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-ia64-ENU.exeSQL Server 2005 Analysis Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-ia64-ENU.exeSQL Server 2005 Integration Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-ia64-ENU.exeSQL Server 2005 Notification Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-ia64-ENU.exeSQL Server 2005 Reporting Serviceshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-ia64-ENU.exeSQL Server 2005 Toolshttp://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-ia64-ENU.exeFor more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online servicesMicrosoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

SQL Server 2005 Post-SP1 hotfixes that are included in SQL Server 2005 build 9.0.2153

Note Microsoft Knowledge Base articles that discuss these hotfixes will be released as they become available.

SQL Bug number

Description

410

Dimension security does not support visual totals on a parent attribute that is in a parent-child dimension.

433

If you execute an ALTER DDL statement that removes dimension hierarchies from the database without removing the hierarchies from the cubes, an access violation may occur.

447

Processing performance on multiprocessor computers is somewhat slower than expected.

459

Under very specific and rare circumstances, a deadlock can occur between two or more sessions in SQL Server 2005. In this case, the internal deadlock monitoring mechanism does not detect the deadlock between the sessions.

461

Page breaks may not be respected when a table is rendered in Microsoft Office Excel if that report contains tables with the conditions of NoRows=true and NoRowsMessage=null, and the table contains a table header or footer.

464

The leaf page of a non-clustered index may have only one index row.

491

On a SQL Server 2005 installation that uses Turkish collation, you cannot view job steps that are of SSIS type from SQL Server Management Studio. If a job has SSIS job steps only, you receive an "Index was outside the bounds of the array. (SqlManagerUI)" error message when you click the Steps tab.

499

A Multidimensional Expressions (MDX) query that involves non-trivial custom rollups when it runs complex sum-like aggregate expressions runs much slower on SQL Server 2005 than on SQL Server 2000.

531

When you run a query or a stored procedure in SQL Server 2005, certain conditions can cause the SQL Server optimizer not to be able to produce an execution plan.

541

An ADOMD.NET application that runs through an IXMLA provider is limited to 32 maximum user sessions.

554

When you query the IS_PLACEHOLDERMEMBER member property for a dimension member by using the .Properties("IS_PLACEHOLDERMEMBER") function in MDX, the value that is returned is always FALSE. This behavior occurs even for members that are placeholders in the dimension.

584

When a report contains an image that is external or is a resource in Reporting Services and the report uses the interactive sorting functionality, the image is replaced by a red x.

606

TheMDSCHEMA_PROPERTIES row set returns the wrong data type for some user-defined properties.

608

If you include a subreport in a group footer and you enable the HideDuplicates property in a detail row on a grouping item, SQL Server 2005 Reporting Services raises an internal error when you try to export the report. The error also occurs when you click Print Preview on the Preview tab in Report Designer.

614

SQL Server 2005 Reporting Services may intermittently display a System.NullReferenceException exception in the ReportSnapshot.EnsureAllStreamsAreClosed procedure. This behavior generates a mini-dump.

615

The SQL Server 2005 Analysis Services service does not start when you use Japanese_Unicode_CI_AS as a collation for the instance of SQL Server 2005 Analysis Services.

617

When you try to run a linked report that uses the User!UserID variable and the execution properties are set to use Snapshots, you receive the following error message:

3wp!library!1!1/27/2006-13:10:27:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:

627

In the Japanese version of SQL Server 2005, the fulltext schedule creation in SQL Server Management Studio fails, and you receive the following error message:

The specified @category_name ('フルテキスト'localized string) does not exist. (Microsoft SQL Server, Error: 14262)

636

A memory leak may occur in the common language runtime (CLR) if you pass a CLR user-defined data type as a parameter by using a stored procedure or the sp_executesql procedure.

652

If Y-axis margins are enabled and the minimum Y-value of all data points is a "nice" integer value, the Y-axis minimum value will be adjusted to a lower value. For example, the chart control rounds 4.0 to 4 to create a "nice" integer value. However, the generated Y-axis labels are incorrect.

664

You run SQL Server 2005 Analysis Services builds 9.00.1520 through 9.00.1539 or SQL Server 2005 SP1. In this case, an MDX query that includes a distinct count measure may not return results. This behavior only occurs if the measure group that is queried contains multiple partitions.

708

The SQL Server Integration Services (SSIS) service does not start when you install SQL Server 2005 SP1

752

The MSMQTask.dll and dependencies are deleted when the fix that is described in the Microsoft Knowledge Base article 910070 is applied.

40000100

If the log reader agent and the DBCC DBREINDEX or ALTER INDEX ...REBUILD commands run at the same time, the log reader agent may miss some transactions to the distributor.

40000102

When you configure Log Shipping and add two or more secondary servers to Log Shipping, only the secondary server that you added last is monitored by the monitor server and the other secondary servers are not.

40000108

The SQL Server 2005 Database Engine Tuning Advisor may unexpectedly exit if indexed views are part of the workload that is tuned.

40000110

The YTD calculation in cubes that use parent-child dimensions may be incorrect.

50000104

TheSqlCommandBuilder.DeriveParameters(SqlCommand) method returns an exception when you execute a stored procedure with an input parameter that is a typed XML type.

50000112

A member of the SQL Server 2005 Analysis Services database administrator role cannot add or delete perspectives. Only a member of the SQL Server 2005 Analysis Services server role can perform such tasks.

50000115

A Report Server Model may use an Analysis Services data source. MDX queries are generated from Report Builder based on the Report Server Model. Dates in the MDX queries have the month and day parts transposed.

50000116

A FETCH operation that uses a KEYSET cursor may be slow if the target table for the cursor has a clustered index and non-clustered indexes. This behavior occurs if the clustered index is the best choice for the FETCH operation and if the SELECT query for the cursor is very simple.

50000120

In SQL Server 2005 Analysis Services, calculated members that are defined in the cube MDX script are resolved before any session or query defined calculations. The only exceptions are certain scenarios with the Aggregate and VisualTotals functions. This behavior is a change from the SQL Server 2000 Analysis Services behavior. In SQL Server 2000 Analysis Services, the Solve Order could be used explicitly to insert a session or a query-defined calculation between two cube level calculations. This change in behavior may cause the query or session scope calculated members not to return the results that you want in SQL Server 2005 Analysis Services. Cumulative hotfix package for SQL Server 2005 (build 9.0.2153) introduces new syntax that allows for control over the scope in which a calculated member is evaluated.

50000151

When you run a SELECT query to return any duplicate rows in a table, incorrect results are returned if the query plan contains a hash aggregation and if one or more of the columns in the table contain a combination of empty strings and undefined characters.

50000154

You may receive a variablelock list error message when you run multiple instances of a package.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

915918 FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005

References

For more information about how to obtain SQL Server 2005 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

913089 How to obtain the latest service pack for SQL Server 2005For more information about the new features and improvements in SQL Server 2005 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

916940 A list of the new features and improvements that are included in SQL Server 2005 Service Pack 1For more information about the naming schema for Microsoft SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:

822499 New naming schema for Microsoft SQL Server software update packages

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.