Icon of program: Microsoft SQL Server Serv…

Microsoft SQL Server Service Pack 2 for Windows

Used Microsoft SQL Server Service Pack 2 for Windows?

Download.com has chosen not to provide a direct-download link for this product and offers this page for informational purposes only.

Editors’ Review

Download.com staff
SQL Server Service Pack 2 provides cumulative fixes for SQL Server 7.0 and MSDE 1.0. It addresses issues and includes all previous updates for enhanced stability and performance.

Top Recommended Alternative

  • Pros

    • Cumulative updates include all previous fixes.
    • Addresses specific discovered issues.
    • Recommended for all new installations.
    • Downloadable in two component parts.
    • Independent component upgrades are supported.

  • Cons

    • Only applies to SQL Server 7.0 and MSDE 1.0.
    • Requires both parts for full system upgrade.
    • MSDE 1.0 requires only database components.
Icon of program: Microsoft SQL Server Serv…

Microsoft SQL Server Service Pack 2 for Windows

Used Microsoft SQL Server Service Pack 2 for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
sp2
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 10
  • Windows NT
  • Windows 98
  • Windows 2000
  • Windows 95
Additional Requirements
Windows 95/98/2000Win NT with NT Service pack 6 installedMicrosoft SQL Server 7 (sp1 not required)
POPULARITY
Total Downloads
5,081
Downloads Last Week
0
Report Software

Program available in other languages

Last Updated

Developer’s Description

By Microsoft
patches and hotfixes for SQL Server 7
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. Because 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. SP2, for SQL Server 7.0 and MSDE 1.0, is in two parts to reduce the size of downloads: Database Components and OLAP Services Components. Database ComponentsSP2 updates for the database components of SQL Server 7.0 and MSDE 1.0 include: Data engine. Database client utilities, such as SQL Server Enterprise Manager and osql for SQL Server 7.0. Database client connectivity components, such as the OLE DB Provider for SQL Server, the SQL Server Open Database Connectivity (ODBC) driver, and the client Net-Libraries. OLAP Services ComponentsSP2 updates for the online analytical processing (OLAP) services components of SQL Server 7.0 include: OLAP Services. OLAP client components, such as OLAP Manager and the OLE DB Provider for OLAP Services. Database client connectivity components, such as the OLE DB Provider for SQL Server, the SQL Server ODBC driver, and the client Net-Libraries. Note: 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. Use only the SP2 Database Components to upgrade MSDE 1.0 components.
Download.com
Your review for Microsoft SQL Server Service Pack 2