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).
The SQL Server 2000 service packs are listed in the following sections. Each service pack section contains the following items:
- A link to download the service pack.
- A link to the fix list that contains the list of issues that are fixed in the service pack.
- A link to the ReadMe file for each service pack. The ReadMe file contains additional useful information about the service pack in plain-text format.
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=888799/
)
A list of the bugs that are fixed in SQL Server 2000 Service Pack 4
888800Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=884525/
)
Additions to the SQL Server 2000 Service Pack 4 readme files
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=330022/
)
SQL Server 2000 Service Pack 3 Readme.htm additions
SQL Server 2000 Service Pack 2
Release date: November 30, 2001
Fix list
For more information, click the following
article number to view the article in the Microsoft Knowledge Base:
306908Â
(http://kbalertz.com/Feedback.aspx?kbNumber=306908/
)
List of bugs fixed by SQL Server 2000 service packs
Readme
889552Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=290212/
)
List of bugs fixed in SQL Server 2000 Service Pack 1 (1 of 2)
300538Â
(http://kbalertz.com/Feedback.aspx?kbNumber=300538/
)
List of bugs fixed in SQL Server 2000 Service Pack 1 (2 of 2)
Readme
889553Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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
(mailto:sqlkb@microsoft.com)
.
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
913089Â
(http://kbalertz.com/Feedback.aspx?kbNumber=913089/
)
How to obtain the latest service pack for SQL Server 2005
321185Â
(http://kbalertz.com/Feedback.aspx?kbNumber=321185/
)
How to identify your SQL Server version and edition
If the resources that are listed in this section do not help you resolve the problem, or if you experience symptoms that differ from those that are described in this article, search the Microsoft Knowledge Base for more information. To search the Microsoft Knowledge Base, visit the following Microsoft Web site:
Next, type the text of the error message that you receive or a description of the problem in the search box.
Note If the problem is not resolved, unfortunately this content is unable to help you any further. So, you might want to ask someone for help, or you might want to visit the following Microsoft Web site: