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
Download details: Microsoft SQL Serve......
You can also see information here:
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:
If you apply the AWE hotfix, you will see:
If you apply the 2187 hotfix, you will see: