Cumulative hotfix package (build 2153) for SQL Server 2005 is available

View products that this article applies to.

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 (http://support.microsoft.com/kb/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.

Back to the top

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 (http://support.microsoft.com/kb/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.

Back to the top

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 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/sql2005-kb918222-x86-enu.exe)

Microsoft SQL Server 2005 Analysis Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/as2005-kb918222-x86-enu.exe)

Microsoft SQL Server 2005 Integration Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/dts2005-kb918222-x86-enu.exe)

Microsoft SQL Server 2005 Notification Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/ns2005-kb918222-x86-enu.exe)

Microsoft SQL Server 2005 Reporting Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/rs2005-kb918222-x86-enu.exe)

SQL Server 2005 Tools
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-x86-ENU.exe (http://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 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/sql2005-kb918222-x64-enu.exe)

SQL Server 2005 Analysis Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/as2005-kb918222-x64-enu.exe)

SQL Server 2005 Integration Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/dts2005-kb918222-x64-enu.exe)

SQL Server 2005 Notification Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/ns2005-kb918222-x64-enu.exe)

SQL Server 2005 Reporting Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/rs2005-kb918222-x64-enu.exe)

SQL Server 2005 Tools
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-x64-ENU.exe (http://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.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/sql2005-kb918222-ia64-enu.exe)

SQL Server 2005 Analysis Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-ia64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/as2005-kb918222-ia64-enu.exe)

SQL Server 2005 Integration Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-ia64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/dts2005-kb918222-ia64-enu.exe)

SQL Server 2005 Notification Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-ia64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/ns2005-kb918222-ia64-enu.exe)

SQL Server 2005 Reporting Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-ia64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/rs2005-kb918222-ia64-enu.exe)

SQL Server 2005 Tools
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-ia64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/sqltools2005-kb918222-ia64-enu.exe)

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 (http://support.microsoft.com/kb/119591/ ) How to obtain Microsoft support files from online services

Microsoft 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.

Back to the top

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.

Collapse this tableExpand this table

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	The MDSCHEMA_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	The SqlCommandBuilder.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 (http://support.microsoft.com/kb/915918/ ) FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005

Back to the top

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 (http://support.microsoft.com/kb/913089/ ) How to obtain the latest service pack for SQL Server 2005

For 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 (http://support.microsoft.com/kb/916940/ ) A list of the new features and improvements that are included in SQL Server 2005 Service Pack 1

For 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 (http://support.microsoft.com/kb/822499/ ) New naming schema for Microsoft SQL Server software update packages

Back to the top

APPLIES TO

Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
Microsoft SQL Server 2005 Enterprise X64 Edition
Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server 2005 Standard X64 Edition
Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems, when used with:

Microsoft SQL Server 2005 Service Pack 1

Microsoft SQL Server 2005 Workgroup Edition
Microsoft SQL Server 2005 Express Edition

Back to the top

atdownload kbsql2005rs kbsql2005engine kbsql2005as kbsql2005ns kbsql2005tool kbsql2005ssis kbsql2005setup kbtshoot kbinfo kbexpertiseinter kbexpertiseadvanced kbqfe KB918222

Back to the top