Microsoft KB Archive/918222

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

Article ID: 918222

Article Last Modified on 11/20/2007

-

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

-



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:  Click Start, click Control Panel, and then click Add or Remove programs. In the Add or Remove Programs window, click the Add or Remove Programs icon. To see the rollup that is listed under your Microsoft SQL Server 2005 installation, select the Show Updates check box.</li> You must uninstall the component packages in the order in which they are listed in this article.</li></ol> </li></ul>

<div class="moreinformation_section">

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

Microsoft SQL Server 2005 Analysis Services

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

Microsoft SQL Server 2005 Notification Services

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

SQL Server 2005 Tools

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

SQL Server 2005 Analysis Services

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

SQL Server 2005 Notification Services

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

SQL Server 2005 Tools

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

SQL Server 2005 Analysis Services

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

SQL Server 2005 Notification Services

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

SQL Server 2005 Tools

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

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.

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

<div class="references_section">