- SUPER SUPER RECOMMENDED
- FatCow Web Hosting Affordable eCommerce Enabled
- Aplus Net Web Hosting Servers
- BlueFish Business Web Hosting Service
- 1and1 Web Hosting Services and Domain Registration
- HostRocket Affordable Web Hosting Service
- HostGator Web Hosting
- Lunarpages Web Hosting Service
- StartLogic Website Hosting
- Netfirms Web Hosting for Small Business
- Bluehost Web hosting Provider
Where is SP4 for SQL Server 2000?
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:
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:
This should yield:
If you apply the AWE hotfix, you will see:
If you apply the 2187 hotfix, you will see:
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 |
Share this:
More about:
- Web Hosting South Africa
- How do I know which version of SQL Server I'm running?
- What do I need to know about SQL Server 2000 SP4?
- SQL Server Versions
- Where can I get this 'Books Online' documentation?
- How to Upgrade to SQL Server 2000 Retail Version After SQL Server 2000 Evaluation Edition Expires (Q
- INF: How to Upgrade to SQL Server 2000 Retail Version After SQL Serve.
- How do I protect myself against the W32.Slammer worm?
- Why can't I install SQL Server on Windows Server 2003?
- How do I upsize my MSDE database to full-blown SQL Server 2000?
- Microsoft Announces Expanded SQL Server 2005 Product Line to Meet Customers' Growing Demands
