How to obtain the latest SQL Server 2000 service pack (290211)



The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services
  • Microsoft SQL Server 2000 Analysis Services 64 bit
  • Microsoft SQL Server 2000 Desktop Engine (MSDE)
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Developer Edition 64 bit
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit
  • Microsoft SQL Server 2000 Enterprise Evaluation Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q290211

SUMMARY

Microsoft distributes bug fixes in service packs. Service packs keep a product current. Service packs include updates and may include system administration tools, drivers, and additional components, which are conveniently bundled for easy downloading. Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, as well as any new fixes. You do not need to install a previous service pack before you install the latest one. For example, you do not need to install SQL Server 2000 Service Pack 1 (SP1) before you install SQL Server 2000 Service Pack 2 (SP2).

Microsoft SQL Server 2000 Service Pack 4

Release date: May 6, 2005

How to obtain

SQL Server 2000 Service Pack 4 (SP4) is available at the following Microsoft Web site:

Fix list

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

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

Readme

There are four separate Readme files for SQL Server 2000 SP4:
  • ReadmeSql2k32asp4.htm: Service Pack 4 for Microsoft SQL Server 2000 Analysis Services
  • ReadmeSql2k32sp4.htm: Service Pack 4 for Microsoft SQL Server 2000 Database Components
  • ReadmeSql2k32desksp4.htm: Service Pack 4 for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
  • ReadmeSql2k64sp4.htm: Service Pack 4 for Microsoft SQL Server 2000 (64-bit)

Readme addendum

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

884525 Additions to the SQL Server 2000 Service Pack 4 Readme.htm file

SQL Server 2000 Service Pack 3a

Release date: May 19, 2003

Note Because most changes 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.

If you have instances that have not yet been upgraded to SP3, however, you should always upgrade those instances directly to SP3a instead of SP3. If you have any copies of the SP3 download files that you were planning to use for future 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.

How to obtain

SQL Server 2000 Service Pack 3a (SP3a) is available at the following Microsoft Web site:

Fix list

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

306908 List of bugs fixed by SQL Server 2000 service packs

Readme

Readme addendum

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

816502 SQL Server 2000 Service Pack 3a Readme.htm additions

SQL Server 2000 Service Pack 3

Release date: January 17, 2003

How to obtain

SQL Server 2000 Service Pack 3 (SP3) is no longer available. Please install SP3a instead.

Fix list

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

306908 List of bugs fixed by SQL Server 2000 service packs

Readme

If you have previously installed SP3, please see the Readme in your download package.

Readme addendum

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

330022 SQL Server 2000 Service Pack 3 Readme.htm additions

SQL Server 2000 Service Pack 2

Release date: November 30, 2001

How to obtain

SQL Server 2000 Service Pack 2 is available at the following Microsoft Web site:

Fix list

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

306908 List of bugs fixed by SQL Server 2000 service packs

Readme

889552 Description of Service Pack 2 for SQL Server 2000: November 9, 2001

SQL Server 2000 Service Pack 1

Release date: June 12, 2001

How to obtain

SQL Server 2000 Service Pack 1 (SP1) is no longer available.

Fix list

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

290212 List of bugs fixed in SQL Server 2000 Service Pack 1 (1 of 2)

300538 List of bugs fixed in SQL Server 2000 Service Pack 1 (2 of 2)

Readme

889553 Description of Service Pack 1 for SQL Server 2000: May 30, 2001


Comments about this or other Microsoft SQL Server Knowledge Base articles? Drop us a note at SQLKB@Microsoft.com.

Modification Type:MajorLast Reviewed:5/6/2005
Keywords:kbGetSP ATdownload kbinfo KB290211 kbAudDeveloper kbAudITPRO