EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

SQL Industry News

SQL Server News

05/12/2005
MS SQL Server Service Pack 4 available

SQL Server 2000 Service Pack 4 (SP4) adds platform support for Microsoft Windows Server 2003 x64 Edition, allowing 32-bit SQL Server 2000 applications to run on 64-bit platforms using the Windows on Windows emulator (WOW64). SP4 addresses specific issues discovered in SQL Server 2000 since its ship date. SP4 is also the first service pack to service the 64-bit edition of SQL Server.

Warning: Microsoft has found an issue with the final build of SP4 that impacts customers who run SQL Server with Address Windowing Extensions (AWE) support enabled. This issue only impacts computers with more than two gigabytes (2 GB) of memory where AWE has been explicitly enabled. If you have this configuration, you should not install SP4. Microsoft is currently working on the problem and will issue an update soon.

Because SQL Server service packs are cumulative, SP4 includes all fixes from previously released Service Pack 1 (SP1), Service Pack 2 (SP2), Service Pack 3 (SP3), and Service Pack 3a (SP3a). SP4 can be applied to an original SQL Server 2000 installation or to one where SP1, SP2, SP3, or SP3a was previously applied.

This service pack includes the MS03-031 security bulletin released in July, 2003.

SQL Server 2000 SP4:

  • Includes a new version of MSXML version 3.0 SP6. With SP4, the OPENXML statement is updated to use a custom-built XML parsing technology designed to be backward compatible with MSXML 2.6.
  • Includes MDAC 2.8 SP1 except for Windows XP and Windows Server 2003 platforms, where it is included with the operating system service packs for those platforms.
  • Adds the following platform support:
    • With Microsoft Windows Server 2003 x64 Edition, SP4 provides support for 32-bit SQL Server applications on 64-bit architectures using the Windows on Windows emulator (WOW64). For more information on specific 64-bit platforms supported, see the Windows Server 2003 x64 Editions Product Overview.
    • With SP4, you can leverage 64-bit processor architectures using 32-bit SQL Server applications when running in WOW64.

      Note: SQL Server 32-bit applications, including SQL server client tools, are still not supported on WOW64 for IA64. Also, currently 32-bit Reporting Services is not supported to run on WOW64 on IA64 and x64 platforms running Windows Server 2003 x64 Edition.
  • Improves documentation; the Readme documents are reorganized into four distinct readme files for the different SP4 components:
    • ReadmeSql2k32sp4: Readme for Service Pack 4 for Microsoft SQL Server 2000 (32-bit)
    • ReadmeSql2k32asp4: Readme for Service Pack 4 for Microsoft SQL Server 2000 Analysis Services
    • ReadmeSql2k32desksp4: Readme for Service Pack 4 for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
    • ReadmeSql2k64sp4: Readme for Service Pack 4 for Microsoft SQL Server 2000 (64-bit)

Benefits

In addition to providing the latest updates and fixes, SQL Server 2000 SP4 provides enhanced performance, security, and serviceability.

Performance

SQL Server 2000 SP4 improves performance on 64-bit systems with 32 or more processors.


Security

SQL Server 2000 SP4 provides:

  • Refreshed, more secure Visual Database Tools (Table Designer, Database Diagrams, and Query Designer).
  • New registry entries to provide additional control over security, metadata, and memory management.

Serviceability

  • SQL Server 2000 SP4 introduces new serviceability functionality that enables you to remove hotfixes applied to SP4 and later versions of SQL Server 2000 running on Microsoft Windows XP and Windows Server 2003.
  • SP4 itself cannot be rolled back.
  • Error reporting can be enabled for selected instances during the SP4 installation.

For descriptions of additional changes, please refer to the readme files for SP4.

Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) and SP4

Users who have an existing instance of MSDE 2000 must know how their instance of MSDE 2000 was installed to know how to update it. In particular, you must know the original package name for your instance of MSDE 2000. To determine the original package name, see the article How To Identify Which MSI File Was Used for an Existing MSDE Installation in the Microsoft Knowledge Base.

  • If the original package name for your instance was SqlRun01.msi through SqlRun16.msi, use the SQL2000.MSDE-KB884525-SP4-x86-ENU.exe file to apply SP4.
  • If the original package name for your instance was Sample.msi or SampleUpg.msi, see the article How To Create Patch Files for the MSDE 2000 Sample.msi File.
  • If your original package name indicates the instance of MSDE 2000 was installed by the Microsoft .NET SDK or Microsoft Application Center, see Microsoft Products that include MSDE 2000 for instructions.
  • If the product code associated with your instance of MSDE 2000 is not listed, then the instance was installed by the setup utility of an application. You cannot use the SQL2000.MSDE-KB884525-SP4-x86-ENU.exe file to apply SP4 to such MSDE instances. Instead, you must get a patch file from the company who wrote the application. If the application came from a company other than Microsoft, you must contact that company for a patch file. If the application came from Microsoft, refer to Microsoft Products that include MSDE 2000 which lists the MSDE applications from Microsoft (this page will be updated with information about how to upgrade these instances of MSDE 2000).

Download SQL Server 2000 SP4

To download SQL Server 2000 SP4, go to the download page, select your language from the drop-down list above, and then click Go.

Additional Information for Partners

Independent software vendors (ISVs) who ship software that runs on either SQL Server 2000 or MSDE 2000 should test for application compatibility with SP4.

For more information, read the Guidance for ISVs Shipping MSDE with Their Products page.

Service or solution providers should encourage all customers running SQL Server 2000 or MSDE 2000 to install SP4.

twitterfacebook