Article ID: 819334
This article contains a synopsis of SQL Server 2000 Service Pack 3a (SP3a).
Microsoft SQL Server 2000 SP3a incorporates changes to SQL Server 2000 Service Pack 3 that address issues raised by the Slammer worm:
SQL Server 2000 SP3a also addresses some setup issues that you might experience with the version of Microsoft Data Access (MDAC) components that is in SQL Server 2000 Service Pack 3 (SP3).
Because most of the changes introduced in SQL Server 2000 SP3a are related to setup, you do not have to apply SQL Server 2000 SP3a to instances of SQL Server 2000 or MSDE 2000 that have already been upgraded to SQL Server 2000 Service Pack 3 (SP3). However, if you have instances that have not been upgraded to Microsoft SQL Server 2000 SP3 yet, you must upgrade those instances to SQL Server 2000 SP3a instead of SQL Server 2000 SP3.
If you have any copies of the SQL Server 2000 SP3 download files that you were planning to use for future upgrades, you must delete those copies and use either the SQL Server 2000 SP3a download files or the SQL Server 2000 SP3a CD-ROM instead. Applications that distribute and install MSDE 2000 must install SQL Server 2000 SP3a instead of SQL Server 2000 SP3.
While you can apply SQL Server 2000 SP3a to instances of SQL Server 2000 SP3 or MSDE 2000 SP3, doing so has little effect on those instances.
Important Note: If you have applied a post SQL Server 2000 SP3-hotfix, you must reinstall that hotfix after you install SQL Server 2000 SP3a. SQL Server 2000 SP3a might regress any post SQL Server 2000 SP3 fixes or files to their original SQL Server 2000 SP3 versions.
This release of SQL Server 2000 SP3a is provided in three parts:
These three parts of SQL Server 2000 SP3a can be applied individually, as follows:
If separate instances of both MSDE 2000 and other editions of the SQL Server 2000 database engine are installed on the same computer, you must apply Desktop Engine SP3a to instances of MSDE 2000, and Database Components SP3a to instances of the SQL Server 2000 database engine, such as Personal Edition, Standard Edition, or Enterprise Edition.
Desktop Engine SP3a is the only part of the service pack that is available in Portuguese (Brazil), Swedish, and Dutch, because SQL Server 2000 Desktop Engine (MSDE 2000) is the only version of SQL Server 2000 that is produced for those languages. The SQL Server 2000 components upgraded by Database Components SP3a or Analysis Services SP3a are not available in those languages. Portuguese (Brazil), Swedish, and Dutch users who want to apply SQL Server 2000 SP3a to a version of SQL Server other than Desktop Engine, must download the SQL Server 2000 SP3a files that match the language of the edition they want to upgrade. For example, English-language SQL Server 2000 SP3a files must be downloaded to upgrade the English-language version of the SQL Server 2000 database engine.
For more information about how to download the service pack, visit the following Microsoft Web site:
SQL Server 2000 Service Pack 3a
How to Identify Your Version of SQL Server or Analysis ServicesUse these techniques to determine what version of SQL Server or Analysis Services you have installed.
To identify what version of the SQL Server 2000 database engine or the MSDE 2000 you have installed, type the following command at the command prompt by using either the osql or the isql utility or by using the Query window in SQL Query Analyzer:
SELECT @@VERSION or SERVERPROPERTY('ProductVersion')
Similarly, you can determine the product level for a particular version of the SQL Server 2000 database engine or MSDE 2000 by running this command:
The following table shows the relationship between:
Collapse this tableExpand this table
If you are not sure what edition of the SQL Server 2000 database engine or MSDE 2000 you are running, view the last line of output returned by SELECT @@VERSION. The last line will match one of the following:
Note The beginning of the line indicates the edition of the SQL Server database engine or MSDE 2000. This is followed by current operating system information.
You can also determine the edition by typing SELECT SERVERPROPERTY('Edition') at the command prompt by using either the osql or the isql utility, or by using the Query window in SQL Query Analyzer.
To identify what version of Analysis Services you have installed, follow these steps:
Collapse this tableExpand this table
How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a
To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a installed, check the version number of the Net-Library file, Ssnetlib.dll. If the version number of this file is 2000.80.760.0, you have SQL Server 2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL Server 2000 SP3a.
Assuming that an instance was installed by using the default settings, you can find the Ssnetlib.dll file in one of these locations:
To find out whether you have the SQL Server 2000 SP3 or SQL Server 2000 SP3a setup folders, open the SP3Readme.htm file. The service pack version, SQL Server 2000 SP3a or SQL Server 2000 SP3, is listed at the top of the first page.
For additional information about SQL Server 2000 SP3a, visit the following Microsoft Web sites:
SQL Server 2000 SP3a Readme.htm
(http://support.microsoft.com/kb/816502/EN-US/ )INF: SQL Server 2000 Service Pack 3a Readme.htm Additions
(http://support.microsoft.com/kb/306908/EN-US/ )INF: List of Bugs Fixed by SQL Server 2000 Service Packs
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack