Summary of differences between sql2000 versions page 1

The SQL Server online help provides a detailed description.
--> Directory
--> SQL Server Architecture
--> Detailed Implementation Rules
--> SQL Server 2000
Various versions of SQL Server 2000
The available versions of Microsoft SQL Server 2000 are as follows:
SQL Server 2000 Enterprise Edition
Used as a production database server. Supports all available functions in SQL Server 2000 and supports the largest Web site
And the performance level required by the Enterprise Online Transaction Processing (OLTP) and data warehouse systems.
SQL Server 2000 Standard Edition
Used as a database server of a small working group or department.
SQL Server 2000 Personal Edition
For mobile users, these users are sometimes disconnected from the network, but the running applications require SQL Server data storage. In the customer
The Personal Edition is also used to run independent applications that require local SQL Server data storage on the user computer.
SQL Server 2000 Development Edition
For programmers to develop applications that use SQL Server 2000 as data storage. Although the development edition supports all functions of the Enterprise Edition,
Allows developers to write and test applications that can use these features, but can only use the development version as a development and testing system.
Can be used as a production server.
SQL Server 2000 for Windows CE
Use Microsoft SQL Server 2000 Windows CE (SQL Server CE) on Windows CE
Store data on the device. You can use SQL Server 2000 of any version to copy data from Windows CE to the primary database.
Keep synchronization.
SQL Server 2000 Enterprise Evaluation Edition
A complete version of the free download function from the Web. This version is only used to evaluate the SQL Server function. After downloading it for 120 days, this version will stop running.
Line.
In addition to these versions of SQL Server 2000, the SQL Server 2000 Desktop Engine component allows application developers
Use their applications to distribute copies of the SQL Server 2000 relational database engine. Because SQL Server 2000 Desktop
The function of the database Engine in the Engine is similar to that of the Database Engine in SQL Server versions, so the Desktop Engine data
The database size cannot exceed 2 GB.
Both the SQL Server 2000 desktop edition and SQL Server 2000 Personal Edition have a concurrency workload Governor, which can execute five concurrently.
The above batch processing time limits the performance of the database engine.
--------------------------------------------------------------------------------
Let me introduce the differences between different versions:
SQL Server 2000 Enterprise Edition
Used as a production database server. Supports all available functions in SQL Server 2000, and supports
Scale the performance required by the Web site and enterprise online transaction processing (OLTP) and data warehouse systems.
SQL Server 2000 Standard Edition
Used as a database server of a small working group or department.
SQL Server 2000 Personal Edition
For mobile users, these users are sometimes disconnected from the network, but the running applications require SQL Server Data Storage
. The Personal Edition is also used to run independent applications that require local SQL Server data storage on the client computer.
SQL Server 2000 Development Edition
For programmers to develop applications that use SQL Server 2000 as data storage. Although the development version supports Enterprise Edition
Functions enable developers to write and test applications that can use these functions. However, developers can only use the development version as a development and testing system.
And cannot be used as a production server.
SQL Server 2000 for Windows CE
Use Microsoft SQL Server 2000 Windows CE edition (SQL Server
CE) data is stored on Windows CE devices. SQL Server 2000 replicas of any version can be used
To synchronize Windows CE data with the master database.
SQL Server 2000 Enterprise Evaluation Edition
A complete version of the free download function from the Web. It is only used to evaluate the SQL Server function; download 120 days later
This version stops running.
These SQL Server 2000 versions also allow application developers to distribute SQL Server with their applications
2000 copies of the relational data stream engine. This component has two names:
SQL Server 2000 Desktop Engine
Microsoft Data Engine (MSDE) 2000
SQL Server books online calls this component A Desktop Engine. Information about the Desktop Engine also applies to MSDE 2000.
Because of the functions of the Database Engine in SQL Server 2000 Desktop Engine and database introduction in SQL Server versions
The volume function is similar, so the size of the Desktop Engine database cannot exceed 2 GB.
Both the SQL Server 2000 desktop edition and SQL Server 2000 Personal Edition have a concurrency workload Governor, which can
When more than five batches are concurrently executed, the performance of the database engine is limited. For more information about the concurrency workload governor
See the SQL Server 2000 database on the desktop.
The following lists some comparisons in online help for reference.