SQL Server 2000

SQL Server 2000 Service Pack 3a (SP3a) addresses specific issues discovered in SQL Server 2000 since its ship date.

Because SQL Server service packs are cumulative, SP3a includes all fixes from previously released Service Pack 1 (SP1), Service Pack 2 (SP2), and Service Pack 3 (SP3). SP3a can be applied to an original installation or to one where SP1, SP2, or SP3 was previously applied.

If you have applied SP3, you do not need to apply SP3a. SP3a is only for SQL Server users who have not applied any versions of SP3. However, you should use SP3a rather than SP3 moving forward.

SQL Server 2000 SP3a:


Improves serviceability for SQL Server 2000 Evaluation Edition. SP3a enables service pack upgrades for trial software. In the past, service packs have not been applicable to trial software.
Includes a new version of Microsoft Data Access Components (MDAC) version 2.71a. This version fixes the installation of MDAC files and a memory leak. These issues are addressed in articles 814572 and 814410 in the Microsoft Knowledge Base.
Disables listening on port 1434 when networking is disabled. This provides further protection from "denial of service" attacks.