The latest post-SQL-2000-SP4 rollup, version 8.0.2187, has a lot of the fixes required, including a fix for the AWE bug.
Microsoft has extended support for SQL 2000 SP4 to 2013, although that is not extended support, ie. no new hotfixes will be produced.
Where I work, we have been upgrading all our SQL 2000 instances to version 8.0.2187, as was suggested to us by MS Support.
There is one issue we have encountered with this version. It is regarding queries involving the numeric data type, and we have had to enable flag 9059 as a startup parameter to revert back to pre-sp4 behavior. Pls see this link for more info on this:
FIX: A query that involves data that is the numeric data type may return incorrect results in SQL Server 2000 SP3 and in earlier SQL Server 2000 service packs:
http://support.microsoft.com/kb/899976
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]