Knowledge Base

List of bugs fixed by SQL Server 2000 service packs

Article ID: 306908

Article Last Modified on 10/29/2007

APPLIES TO

Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q306908

SUMMARY

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

MORE INFORMATION

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.

SQL Server 2000 Service Pack 3

All fixes in SP3

Click here to view a list of Microsoft SQL Server 2000 SP3 fix articles

SQL Server 2000 Service Pack 2

All fixes in SP2

Click here to view a list of Microsoft SQL Server 2000 SP2 fix articles

SQL Server 2000 Service Pack 1

For more information about the problems that are fixed in SQL Server 2000 Service Pack 1, click the following article numbers to view the articles in the Microsoft Knowledge Base:

290212 SQL Server 2000 Service Pack 1 Fixlist (1 of 2)

300538 SQL Server 2000 Service Pack 1 Fixlist (2 of 2)

REFERENCES

For more information about how to obtain the latest service pack for SQL Server 2000, click the following article numbers to view the articles in the Microsoft Knowledge Base: