This article was previously published under Q232570
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how to obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0. To see a complete list of bugs that are fixed by this update, see the following article in the Microsoft Knowledge Base:
To determine which Service Pack level your SQL Server is currently running, execute the following statement from a Query Analyzer window:
The result of this query will be 7.00.623 if you are running SQL Server 7.0 with no service pack applied or 7.00.699 for SQL Server 7.0 Service Pack 1.
NOTE: This service pack is for use only by holders of a current valid Microsoft SQL Server version 7.0 license. This service pack addresses some specific problems that were discovered in SQL Server version 7.0 after it began shipping. Microsoft recommends that all Microsoft SQL Server version 7.0 users apply this service pack.
Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 is available for Intel (x86) and Alpha-basedcomputers.
Instructions for Downloading
To download Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0, do the following: