INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

ID: Q232570

The information in this article applies to:

Microsoft SQL Server version 7.0

SUMMARY

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:

Q225019 - INF: SQL Server 7.0 Service Pack 1 Fixlist

To determine which Service Pack level your SQL Server is currently running, execute the following statement from a Query Analyzer window:


SELECT @@version

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-based computers.

Instructions for Downloading

To download Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0, do the following:

Connect to the Microsoft Download Center at http://www.microsoft.com/downloads/search.asp?.

Select Product as your Search criteria.

Select SQL Server 7.0 from the Product Name box.

Select the operating system installed on your SQL Server computer from the Operating System drop-down list box.
NOTE: If you have an Alpha computer, be sure to select Windows NT (DEC Alpha).

Click the Find It! button.

Click the title of the download you want. To facilitate downloading, the service pack has been broken into two parts. There are the Database Components SP1 and the OLAP Services Components SP1.

Click the link to the self-extracting service pack executable file under Download Now.

Select Save This Program to Disk to copy the download to your computer for installation at a later time.

Run the self-extracting executable file to expand the service pack into its component files and then run the setup program.

MORE INFORMATION

If you need more information or assistance regarding this service pack, please contact your primary support provider.

Additional query words: prodsql sql7 servpack patch msnSQL fix sp1 sp sqlfaqtop MSL soft lib softlib update

Keywords : kbSQLServ700sp1fix
Version : winnt:7.0
Platform : winnt
Issue type : kbhowto kbinfo