Article ID: 916287 - View products that this article applies to.
Microsoft SQL Server 2000 hotfixes are created for specific SQL Server service packs. For example, you cannot apply a hotfix that was designed for SQL Server 2000 Service Pack 3 (SP3) to an installation of SQL Server 2000 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. 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 a SQL Server service pack is 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 is not included in the next SQL Server service pack:
810185Any SQL Server 2000 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 SQL Server 2000 SP3 hotfix that was included in build 8.00.1000 or in a later build is not included in SQL Server 2000 SP4.
(http://support.microsoft.com/kb/810185/ )SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a
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 SQL Server 2000 SP3 hotfix that was included in that range of builds is included in SQL Server 2000 SP4 build 8.00.2187. This build is also known as build 2187.
The installer does not install this hotfix correctly on x64-based systems. This installation issue occurs when the following conditions are true:
How to obtain the cumulative hotfix packageTo obtain the cumulative hotfix package for x86-based operating systems and for x64-based operating systems, visit the following Microsoft Download Center Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=9C9AB140-BDEE-44DF-B7A3-E6849297754ATo obtain the cumulative hotfix package for Itanium-based operating systems, visit the following Microsoft Download Center Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=1705BD2F-1FB8-4EC8-B3DB-0935361308C7For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591Microsoft 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.
(http://support.microsoft.com/kb/119591/ )How to obtain Microsoft support files from online services
SQL Server 2000 build 8.00.2187
(http://support.microsoft.com/kb/916287/ )A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187
(http://support.microsoft.com/kb/914298/ )FIX: You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data