A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162 (904660)



The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions) SP4

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 SP4

  • 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 SP4

  • No hotfixes for Microsoft SQL Server 2000 Analysis Services are included in this cumulative hotfix package. For more information about a cumulative hotfix package for SQL Server 2000 Analysis Services, click the following article number to view the article in the Microsoft Knowledge Base:

    907323 Hotfix rollup package for SQL Server 2000 Analysis Services Service Pack - Build 2174

MORE INFORMATION

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

Post-SP3 hotfixes that are included in SQL Server 2000 post-SP4 build 8.00.2162

900625 FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000

893172 FIX: An access violation may occur when you use the READPAST lock hint and you use a non-clustered index in your query in SQL Server 2000

892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000

891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000

891268 FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operations

891201 FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000

891017 FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation

892935 FIX: You experience slow performance when you join local partitioned views with a table in SQL Server 2000

892840 FIX: 17883 errors may be written to the SQL Server error log when you run a query that generates many floating point exception errors in SQL Server 2000

894257 FIX: You receive an "Incorrect syntax near ')'" error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000

897572 FIX: You may receive a memory-related error message when you repeatedly create and destroy an out-of-process COM object within the same batch or stored procedure in SQL Server 2000

896985 FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 Service Pack 3

887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000

897578 FIX: Only the master database and the tempdb database are listed when you try to create a new job in SQL Server Enterprise Manager

892551 FIX: You receive a SqlException error message when you call the sp_addmergepublication stored procedure when the Active Directory directory service is not available in SQL Server 2000

892392 FIX: Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column

892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation

892940 FIX: You experience delays and receive a 17883 error message when SQL Server 2000 performs a large and complex query plan that uses hash operators

894254 FIX: A complex query that includes a UNION ALL operator and an EXISTS clause may fail in SQL Server 2000

891866 FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000

892985 FIX: You may experience unexpected delays in query execution and unexpected time-out situations, and you may receive error message 17883 when you use the BULK INSERT command in SQL Server 2000

896425 FIX: The BULK INSERT statement silently skips insert attempts when the data value is NULL and the column is defined as NOT NULL for INT, SMALLINT, and BIGINT data types in SQL Server 2000

896980 FIX: The query plan may take longer than expected to compile, and you may receive error message 701, error message 8623, or error message 8651 in SQL Server 2000

898115 FIX: The subquery in a CASE function is evaluated even if the condition in the WHEN expression is false in SQL Server 2000

902851 FIX: SQL Server 2000 may intermittently appear to stop responding (hang) during a scheduled maintenance DBCC DBREINDEX operation

892310 FIX: The results are different every time that you run a complex query that contains a hash outer join operator in SQL Server 2000

895187 FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000

900335 FIX: The SQL Server 2000 automatic database recovery operation may not succeed if an index contains a FLOAT data type or a REAL data type, and this data type contains a NaN value

900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000

902852 FIX: Error message when you run an UPDATE statement that uses two JOIN hints to update a table in SQL Server 2000: "Internal SQL Server error"

898709 FIX: Error message when you use SQL Server 2000: "Time out occurred while waiting for buffer latch type 3"

905765 FIX: A view is corrupted after you run the DBCC DBREINDEX Transact-SQL statement to rebuild the clustered index on a view in SQL Server 2000


Modification Type:MinorLast Reviewed:9/15/2006
Keywords:kbtshoot kbinfo kbHotfixServer kbQFE KB904660 kbAudDeveloper kbAudITPRO