Overview

What is Microsoft SQL Server Service Pack 2 (SP2)?

addresses specific issues that were discovered in SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 since their ship date.

In depth

A closer look at Microsoft SQL Server Service Pack 2 (SP2)

Since SQL Server Service Packs are cumulative, SP2 includes all fixes from Service Pack 1 (SP1) and can be applied to an original installation or to one where SP1 was previously applied.

It is recommended that you include SP2 in all new SQL Server 7.0 and MSDE 1.0 installations.

Service Pack 2 for SQL Server 7.0 and MSDE 1.0, is in two parts to reduce the size of downloads. The first download is Database Components and the second download is OLAP Services Components.

Database Components updates for the database components of SQL Server 7.0 and MSDE 1.0 include: data engine, database client utilities, and database client connectivity components.

OLAP Services Components include: OLAP services, OLAP client components, and database client connectivity components.

SQL Server 7.0 sites can use the SP2 Database Components to upgrade their database components without upgrading their OLAP Services components and vice versa. To upgrade both database components and OLAP Services components for your SQL Server 7.0 site, you must apply both parts of the service pack. To upgrade MSDE 1.0 components, you should use only the SP2 Database Components.

Verdict

Should you download Microsoft SQL Server Service Pack 2 (SP2)?

Microsoft SQL Server Service Pack 2 (SP2) runs on Windows NT/2000/Windows 10/11 and is available under the Freeware license — the installer is 42 MB. We’ve catalogued it under Databases.

Verified clean. Every Microsoft SQL Server Service Pack 2 (SP2) build on SoftLookup is scanned for viruses, spyware, adware, trojans and backdoors. We re-test on every update.