I just noticed that Microsoft have updated their SQL site with the release of SP2 for SQL Server 2000. System admins, grab this. View our previous Beta announcement and a list of bug fixes planned for SP2 here.
SQL Server 2000 Service Pack 2 (SP2) addresses specific issues that were discovered in SQL Server 2000 since its ship date.
Because SQL Server Service Packs are cumulative, SP2 includes all fixes from previously released Service Pack 1 (SP1), and can be applied to an original installation or to one where Service Pack 1 (SP1) was previously applied.
News source: International SQL Server 2000 SP2 Site