SQL Server is a relational database management system. It was originally developed by Microsoft Sybase and Ashton-Tate three companies jointly developed in 1988 introduced the first OS / 2 version. In the introduction of Windows NT, Microsoft SQL Server and Sybase in the development of on separate ways. Microsoft SQL Server will be ported to Windows NT system, focusing on the development and promotion of SQL Server in Windows NT version. Sybase SQL Server are more focused on applications in the UNIX operating system.
SQL Server 2000, Microsoft has introduced is the SQL Server database management system, the new version. This version has the advantages of SQL Server 7.0 version, it increases are higher than in many more advanced features, with easy to use, good scalability, and high level of software integration advantages. Can cross from the laptop running Microsoft Windows 98 computer, running Microsoft Windows 2000 large-scale multi-processor servers and other platforms.
The common version of SQL Server 2000
* Enterprise Edition (Enterprise Edition)
Support for all SQL Server 2000 features, can be used as large-scale Web sites, enterprise OLTP (online transaction processing) and data warehouse systems, database server products.
* Standard Edition (Standard Edition)
For small working groups or departments
* Personal Edition (Personal Edition)
For stand-alone systems or client
* Developer Edition (Developer Edition)
For programmers to develop applications programs that require SQL Server 2000 as a data storage device.
In addition, SQL Server 2000 Desktop Engine also (Desktop Engine), and Windows CE version. Users can choose to be based on actual installed version of SQL Server 2000.
Running SQL Server 2000 minimum hardware and software requirements
1 Hardware Requirements
1, the computer
Intel-compatible computer, Pentium 166 MHz or more.
2, the memory RAM
Enterprise: version 64 MB.
Standard: Version 32 MB.
3, hard disk space
SQL Server 2000:
* Fully installed (Full) 180 MB
* Typical installation (Typical) 170 MB
* Minimal installation (minimum 65) MB
* Only install the management tools (Client tools only) 90 MB
Analysis Services: 50 MB
English Query: 12 MB
2 Software Requirements
1, the operating system
The common operating system and can install SQL Server 2000 version of the relationship shown in Table 2-1, where "Y" that can be installed in the corresponding version, "N" that can not install the corresponding version.
Note: The table in the Windows NT Server 4.0 family of operating systems to install Service Pack 5 (SP 5) or more advanced software compression package
2, network software
If you use the operating system is Microsoft Windows NT, Windows 2000, Windows 98 or Windows95, you do not need to install additional networking software. And SQL Server 2000 supports Windows NT Workstation, Windows 2000 Professional, Windows 98, Windows 95, Apple Macintosh, OS / 2 and UNIX clients to connect.