Article ID: 273914 - View products that this article applies to.
This article was previously published under Q273914
This article has been archived. It is offered "as is" and will no longer be updated.
The "More Information" section of this article contains the Readme.txt file for the Microsoft SQL Server 6.5 Post Service Pack 5a Update.
NOTE: The text provided in this article is more recent than the text of the Readme.txt file included in the download package.
To see a list of problems that are fixed by the SQL Server 6.5 Post Service Pack 5a Update, see the following article in the Microsoft Knowledge Base:
274035To download the SQL Server 6.5 Post Service Pack 5a Update, see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/274035/EN-US/ )INF: SQL Server 6.5 Post Service Pack 5a Update Fixlist
(http://support.microsoft.com/kb/274036/EN-US/ )INF: How to Obtain SQL Server 6.5 Post Service Pack 5a Update
Microsoft SQL Server 6.5 Post Service Pack 5a UpdateSeptember 12, 2000
(c) Copyright Microsoft Corporation, 2000. All rights reserved.
This server update contains an updated database engine that is for use only by holders of a current, valid Microsoft SQL Server version 6.5 license. It addresses some specific problems that were discovered in SQL Server 6.5 Service Pack 5a after it was shipped. If you are running SQL Server 6.5 Service Pack 5 or 5a, it is recommended that you apply this update to your system only if your configuration is affected by problems that are fixed by this update.
The updated database engine (Sqlservr.exe file) and associated files are included in the following self-extracting zipped files for Intel and Alpha processor architectures:
Sql65sp5updatei.exe for IntelThis Post Service Pack 5a Update can be applied to all shipped versions of SQL Server version 6.5 that currently have either Service Pack 5 or Service Pack 5a applied. This includes SQL Server 6.5 Enterprise Edition and the SQL Server version included with Microsoft Small Business Server (SBS). For more information about determining whether you can apply the update to your specific version of SQL Server 6.5, see the "Service Pack Versions" section below.
Sql65sp5updatea.exe for Alpha
The Sql65sp5updatei.exe and Sql65sp5updatea.exe files are self-extracting executable files. When you run them, one of the files that is extracted is Fixlist.htm. Fixlist.htm contains a list of the fixes included in the Post Service Pack 5a Update.
This Post Service Pack 5a Update contains fixes for problems reported by customers after Microsoft released SQL Server 6.5 Service Pack 5a. Because this update contains only a new database engine, you must have applied either SQL Server 6.5 Service Pack 5 or Service Pack 5a before applying this update.
With the release of SQL Server 2000, Microsoft has begun phasing out future support for SQL Server version 6.5. After December 31, 2000, Microsoft will support SQL Server version 6.5 on a best effort basis. This means that a customer can call Microsoft Product Support Services (PSS) with SQL Server version 6.5 issues; however, the support will not include changes in code to SQL Server version 6.5, and additional service packs for version 6.5 will not be released.
This update does not change the year 2000 compliance statement for SQL Server 6.5.
Service Pack VersionsIf you are not sure which service pack you have installed on a computer running SQL Server, you can verify the version by issuing SELECT @@VERSION from either ISQL or ISQL/w. The following table illustrates the correspondence between the version string reported by @@VERSION for each of the SQL Server 6.5 service packs:
Collapse this tableExpand this table
NOTE: You should apply the Post Service Pack 5 Update only if the version of your existing installation is between 6.50.415 and 6.50.479. If you have a version earlier than 6.50.415, you must first apply Service Pack 5a, and then apply the Post Service Pack 5 Update. If you have a version of 6.50.479 or greater, you cannot apply the Post Service Pack 5 Update.
Language Versions of SQL ServerThe Post Service Pack 5 Update can be applied to any language version (English, French, German, Japanese) of SQL Server 6.5 Service Pack 5 or Service Pack 5a.
Installing the Post Service Pack 5a UpdatePlease read through these instructions thoroughly before proceeding with any steps of the installation.
PrerequisitesYou must install SQL Server 6.5 Service Pack 5 or Service Pack 5a before applying this update. Instructions for downloading SQL Server 6.5 Service Pack 5a are at:
Installation Process for the Post Service Pack 5a UpdateThe Post Service Pack 5a Update contains the following files:
Collapse this tableExpand this table
If you are installing the Post Service Pack 5a Update on a server running SQL Server 6.5 Enterprise Edition that has clustering enabled, please use the section titled Installation Steps for SQL Server 6.5 Enterprise Edition with Clustering Enabled for installation instructions. All other environments should use the section titled Standard Installation Steps.
Standard Installation StepsTo install the SQL Server 6.5 Post Service Pack 5a Update, perform the following steps:
Installation Steps for SQL Server 6.5 Enterprise Edition with Clustering EnabledTo install the SQL Server 6.5 Post Service Pack 5a Update on a computer with clustering enabled, perform the following steps: