Microsoft KB Archive/933097

= Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available =

Article ID: 933097

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
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Express Edition

-



Microsoft distributes Microsoft SQL Server 2005 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2005 fix release.



INTRODUCTION
Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 2 (SP2) hotfix to an installation of SQL Server 2005 SP2. 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 SP2 includes all the SQL Server 2005 hotfixes up to and including build 9.0.2211. For more information about which SQL Server 2005 hotfixes are included in SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:

921896 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2

Cumulative hotfix package (build 3152) for SQL Server 2005 SP2 contains the SQL Server 2005 hotfixes that were not included in SQL Server 2005 SP2. This build approximately corresponds to build 9.0.2214 through build 9.0.2219.

Note This hotfix rollup build is also known as build 3152.

Important notes about the cumulative hotfix package

 * SQL Server 2005 hotfixes are now multilanguage. There is only one cumulative hotfix package for all languages.
 * One cumulative hotfix package includes all the component packages. The cumulative hotfix package is designed to update 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 hotfix 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).
 * To uninstall the cumulative hotfix package, follow these steps:
 * Click Start, click Control Panel, and then click Add or Remove Programs.
 * In Add or Remove Programs, click Change or Remove Programs.
 * To see all the updates for the SQL Server 2005 installation, click to select the Show Updates check box.
 * Uninstall the cumulative hotfix package.



Cumulative hotfix package for x86-based operating systems
If you are running any component of SQL Server 2005 on an x86-based operating system, you must install the following package. The following file is available for download from the Microsoft Download Center:

Download the SQLServer2005-KB933097-x86-ENU.exe package now.

Release Date: March 7, 2007

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.

Cumulative hotfix package for x64-based operating systems
If you are running any component of SQL Server 2005 on an x64-based operating system, you must install the following package. The following file is available for download from the Microsoft Download Center:

Download the SQLServer2005-KB933097x64-ENU.exe package now.

Release Date: March 7, 2007

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.

Cumulative hotfix package for Itanium-based operating systems
If you are running any component of SQL Server 2005 on an Itanium-based operating system, you must install the following package. The following file is available for download from the Microsoft Download Center:

Download the SQLServer2005-KB933097-IA64-ENU.exe package now.

Release Date: March 7, 2007

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-SP2 hotfixes that are included in SQL Server 2005 build 9.0.3152
Note Microsoft Knowledge Base articles that discuss these hotfixes will be released as they become available.

Cumulative update file information
This cumulative update contains only those files that are required to correct the issues that this article lists. This cumulative update may not contain of all the files that you must have to fully update a product to the latest build.

The English version of this cumulative hotfix 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 Tools, Itanium architecture version
