Article ID: 904660
Article Last Modified on 6/27/2007
APPLIES TO
- Microsoft SQL Server 2000 Service Pack 4
This package has been replaced by an updated version. For information about how to obtain the updated cumulative package, click the following article number to view the article in the Microsoft Knowledge Base:
916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187
INTRODUCTION
Microsoft SQL Server 2000 hotfixes are created for a specific Microsoft SQL Server service pack. For example, you cannot apply a hotfix that was designed for Microsoft SQL Server 2000 Service Pack 3 (SP3) to an installation of Microsoft SQL Server 2000 Service Pack 4 (SP4) unless a special case is noted for that hotfix. You must apply a SQL Server 2000 SP3 hotfix to an installation of SQL Server 2000 SP3. And you must apply a SQL Server 2000 SP4 hotfix to an installation of SQL Server 2000 SP4.
By default, any hotfix that is provided in one SQL Server service pack will be included in the next SQL Server service pack. For example, the SQL Server 2000 SP3 hotfixes are included in SQL Server 2000 SP4.
However, there are two special cases where a hotfix will not be included in the next SQL Server service pack:
- If the hotfix was released after the next service pack was locked down for Beta testing: For Beta testing to be effective, the testing must cover most of the changes that will be included in the product. Therefore, at some time, we have to decide what will be included in the final version of a service pack. We must lock down the contents so that we can create the Beta version that customers will test. After the service pack has been locked down, only critical changes may be added to the lock-down version of the service pack.
- If the hotfix was released after the next service pack was released: After any service pack is burned to CD and released, we cannot change that service pack.
The lock-down build of SQL Server 2000 SP3 hotfixes that is included in SQL Server 2000 SP4 is build 8.00.0996. To determine which SP3 hotfixes are included in SQL Server 2000 SP4, see the cumulative hotfix list for SQL Server 2000 SP3 in the following Microsoft Knowledge base article:
810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a
Any SP3 hotfix that was included in build 8.00.0996, or in an earlier build, is included in SQL Server 2000 SP4.
By default, any SP3 hotfix that was included in build 8.00.1000, or in a later build, is not included in SQL Server 2000 SP4.
This cumulative hotfix package contains the SQL Server 2000 SP3 hotfixes that roughly correspond to build 8.00.1009 through build 8.00.1031, inclusive. Therefore, any SP3 hotfix that was included in that range of builds is included in SQL Server 2000 SP4 build 8.00.2162. This build is also known as build 2162.
Important notes:
- If you are currently running a SQL Server 2000 SP3 build that is between build 8.00.1009 and build 8.00.1031, you should test SQL Server 2000 SP4 before you upgrade. Or, upgrade to SQL Server 2000 SP4 and then immediately install this cumulative hotfix package.
- If you are running a SQL Server 2000 SP3 build that is later than build 8.00.1031, you may require a later hotfix than this package contains. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
894905 Cumulative list of the hotfixes that are available for SQL Server 2000 Service Pack 4
- SP3 hotfixes that were included in build 8.00.1032, and in later builds, are included in later SQL Server 2000 SP4 builds. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
894905 Cumulative list of the hotfixes that are available for SQL Server 2000 Service Pack 4
MORE INFORMATION
The installer does not install this hotfix correctly on x64-based systems. This installation issue occurs when the following conditions are true:
- The system uses the Advanced Micro Devices (AMD) AMD64 processor architecture or the Intel Extended Memory 64 Technology (EM64T) processor architecture.
Note This issue does not occur on systems that use the Intel Itanium processor architecture.
- The system is running a 64-bit version of the Microsoft Windows Server operating system.
- The system is running a 32-bit version of SQL Server 2000.
We have corrected this installation issue in later builds of SQL Server 2000, starting with version 8.00.2244. When a customer who is running SQL Server 2000 on an x64-based system requests this hotfix, we will provide a build that includes this hotfix and that can be installed correctly on an x64-based system. The build that we provide will be version 8.00.2244 or a later version.
How to obtain the package
This package has been replaced by an updated version. For information about how to obtain the updated cumulative package, click the following article number to view the article in the Microsoft Knowledge Base:
916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187
SQL Server 2000 build 8.00.2162
904660 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162
Additional query words: cumulative roll up 1024 equivalent
Keywords: kbtshoot kbinfo kbhotfixserver kbqfe KB904660
