MS SQL Basics Tutorial: Version and System requirements for SQL Server 2000

The common versions of SQL Server 2000 are as follows:

• Enterprise Edition (Enterprise Edition)

Supports all SQL Server 2000 features and can serve as a product database server for large Web sites, enterprise OLTP (online transaction processing), and data warehousing systems.

• Standard Edition (Standard Edition)

For a small workgroup or department

• Personal Edition (Personal Edition)

For stand-alone systems or clients

• Developer version (Developer Edition)

For programmers to develop applications that require SQL Server 2000 as a data storage device.

In addition, SQL Server 2000 also has a Desktop Engine (Desktop Engine) and Windows CE Edition. The user can choose the version of SQL Server 2000 to install according to the actual situation.

The minimum hardware and software requirements for running SQL Server 2000 are as follows:

2.2.1 Hardware Requirements

1, computer

Intel compliant computers, Pentium 166 MHz.

2, Memory Ram

Enterprise: Version MB.

Standard: Version MB.

3. Hard disk space

SQL Server 2000:

• Fully installed (full) 180 MB

• Typical installation (typical) 170 MB

• Minimum installation (minimum) MB

• Install only Administrative tools (Client tools only) MB

Analysis Services:50 MB

中文版 Query:12 MB

2.2.2 Software Requirements

1. Operating system

The relationship between the commonly used operating systems and the version of the installable SQL Server 2000 is shown in table 2-1, where "Y" indicates the version that can be installed, and "N" indicates the corresponding version that cannot be installed.

Note: the Windows NT Server 4.0 Series operating system in the previous table requires the installation of Service Pack 5 (SP 5) or more advanced Compression pack software

2, network software

If you are using an operating system that is Microsoft Windows NT, Windows 2000, Windows 98, or WINDOWS95, you do not need to install additional network software. and SQL Server 2000 supports Windows NT Workstation, Windows Professional, Windows 98, Windows 95, Apple Macintosh, OS/2, and UNIX client company Pick up.

View a complete set of "MS SQL Primer Tutorials" >>>>>