If you are running SQL Server 2000 SP4 (build 8.00.2039), you might be interested in this blog.
Any 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.
As a result, if you are running SP3 build 8.00.1000 or above, and you move to SP4 (build 8.00.2039), these hotfixes will not be installed by default.
In such a case, we recommend that you also consider the SP4 cumulative hotfix package 2187. 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.
We strongly recommend that you test any service pack or hotfix builds on your test server before putting them on your production server.
POSTED BY : Sanchan Saxena