Help and Support
 

powered byLive Search

List of bugs fixed by SQL Server 2000 service packs

Article ID:306908
Last Review:October 29, 2007
Revision:11.2
This article was previously published under Q306908
On This Page

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 (http://support.microsoft.com/kb/290211/) How to obtain the latest SQL Server 2000 service pack

Back to the top

MORE INFORMATION

SQL Server 2000 Service Pack 4

888799 (http://support.microsoft.com/kb/888799/) A list of the bugs that are fixed in SQL Server 2000 Service Pack 4
888800 (http://support.microsoft.com/kb/888800/) A list of the bugs that are fixed in SQL Server 2000 Analysis Services Service Pack 4

Back to the top

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 (http://support.microsoft.com/kb/814572/) FIX: SQL Server does not start and an access violation occurs after you install SQL Server 2000 Service Pack 3
814410 (http://support.microsoft.com/kb/814410/) FIX: Performance degradation and memory leak in the ODBC Driver for SQL Server
814130 (http://support.microsoft.com/kb/814130/) How to help secure network connectivity for SQL Server 2000 local databases
Additionally, SP3a contains all the fixes that are listed for SP3.

Back to the top

SQL Server 2000 Service Pack 3

All fixes in SP3

Click here to view a list of Microsoft SQL Server 2000 SP3 fix articles (http://support.microsoft.com/search/default.aspx?catalog=lcid%3d1033&spid=global&query=kbsqlserv2000sp3fix&adv=)

Back to the top

SQL Server 2000 Service Pack 2

All fixes in SP2

Click here to view a list of Microsoft SQL Server 2000 SP2 fix articles (http://support.microsoft.com/search/default.aspx?catalog=lcid%3d1033&spid=global&query=kbsqlserv2000presp2fix&adv=)

Back to the top

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 (http://support.microsoft.com/kb/290212/) SQL Server 2000 Service Pack 1 Fixlist (1 of 2)
300538 (http://support.microsoft.com/kb/300538/) SQL Server 2000 Service Pack 1 Fixlist (2 of 2)

Back to the top

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:
290211 (http://support.microsoft.com/kb/290211/) How to obtain the latest SQL Server 2000 service pack

Back to the top


APPLIES TO
Microsoft SQL Server 2000 Standard Edition

Back to the top

Keywords: 
kbproductlink kbinfo KB306908

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.