This article was previously published under Q306908
This article contains information about the bugs that are fixed by SQL Server 2000 service packs. Because service packs are cumulative, later service packs also fix the bugs that are fixed by earlier service packs. For example, SQL Server 2000 Service Pack 2 (SP2) has the bug fixes from SQL Server 2000 Service Pack 1 (SP).
For more information about how to obtain SQL Server 2000 service packs, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
SQL Server 2000 Service Pack 4
888799 A list of the bugs that are fixed in SQL Server 2000 Service Pack 4
888800 A list of the bugs that are fixed in SQL Server 2000 Analysis Services Service Pack 4
SQL Server 2000 Service Pack 3a
Note Because most changes that are introduced in SP3a are related to Setup, you do not need to apply SP3a to instances of SQL Server 2000 or MSDE 2000 that have already been upgraded to SP3.
however, if you have instances that have not yet been upgraded to SP3, you should always upgrade those instances directly to SP3a instead of to SP3.
If you have any copies of the SP3 download files that you were planning to use for later upgrades, you should delete those copies and instead use either the SP3a download files or the SP3a CD-ROM. Applications that distribute and install MSDE 2000 should install SP3a instead of SP3.
While you can apply SP3a to instances of SQL Server 2000 SP3 or MSDE 2000 SP3, doing so has little effect on those instances.
Fixes that are specific to SP3a
814572 FIX: SQL Server does not start and an access violation occurs after you install SQL Server 2000 Service Pack 3
814410 FIX: Performance degradation and memory leak in the ODBC Driver for SQL Server
814130 How to help secure network connectivity for SQL Server 2000 local databases
Additionally, SP3a contains all the fixes that are listed for SP3.