Web Hosting and Dedicated Servers

Yes, it has been a long time since there has been a major service pack for SQL Server 2000. On May 6, 2005, the much anticipated Service Pack 4 was released.

The main page is here...

You can also see information here:

• KB #888799 A list of the bugs that are fixed in SQL Server 2000 Service Pack 4
  
  
• KB #884525 Additions to the SQL Server 2000 Service Pack 4 readme files
  
  
• English download page

---

IF YOU ARE RUNNING AWE

You should also apply the .2040 AWE hotfix after applying SP4. For information from the source, see KB #899761.

---

And after that, to avoid complications with BULK INSERT, and to be sure that both nodes of a cluster were installed correctly, you should install the cumulative hotfix (build 2187) available in KB #916287.

You should download and install these updates, even if you are running client tools only. However, the update has not been tested on platforms such as Windows 98, Windows ME and Windows NT 4.0. So, if you are running those platforms, please proceed with caution (or upgrade your operating system first).

After you have installed the Service Pack and restarted SQL Server, you can confirm the successful installation by running the following query in Query Analyzer:

SELECT SERVERPROPERTY('productversion') SELECT SERVERPROPERTY('productlevel')

This should yield:

8.00.2039 SP4

If you apply the AWE hotfix, you will see:

8.00.2040 SP4

If you apply the 2187 hotfix, you will see:

8.00.2187 SP4

[ Comment, Edit or Article Submission ]