The SQL Server online Help gives detailed instructions.
--> Directory
-->sql Server Architecture
--> Implementation Rules
-->sql Server 2000 Version
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 features in SQL Server 2000 and can be supported by the largest WEB site
Scale to the level of performance required by enterprise online transaction processing (OLTP) and data warehousing systems.
SQL Server 2000 Standard Edition
Used as a database server for a small workgroup or department.
SQL Server 2000-person Edition
For mobile users who sometimes disconnect from the network, but the applications they run require SQL Server data storage. In the Guest
A personal version is also used when running stand-alone 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 a data store. Although the development version supports all the features of the Enterprise Edition,
Enables developers to write and test applications that can use these features, but can only use the development version as a development and test system, without
Can be used as a production server.
SQL Server Windows CE Edition
Use the Microsoft®sql server 2000™WINDOWS®CE version (SQL Server CE) in Windows CE
Data storage on the device. Can replicate data with any version of SQL Server 2000 to make Windows CE data and the primary database
Keep synchronized.
SQL Server 2000 Enterprise Evaluation Edition
A full-featured version that can be downloaded free of charge from the Web. Evaluates SQL Server functionality only; 120 days after download this version will stop shipping
Yes.
In addition to these versions of SQL Server 2000, the SQL Server Desktop Engine component allows application developers
Distribute a copy of the SQL Server 2000 relational database engine with their application. Because SQL Server Desktop
The database engine in Engine is functionally similar to the database engine in each version of SQL Server, so Desktop Engine data
The size of the library cannot exceed 2 GB.
SQL Server 2000 desktop and SQL Server 2000 editions have a concurrent workload governor that can execute 5 concurrent
The above batch process restricts the performance of the database engine.
--------------------------------------------------------------------------------
Let me start by introducing the different versions:
SQL Server 2000 Enterprise Edition
Used as a production database server. Supports all available features in SQL Server 2000, and can be supported by the largest
Scale the level of performance required for WEB sites and Enterprise online transaction processing (OLTP) and data warehousing systems.
SQL Server 2000 Standard Edition
Used as a database server for a small workgroup or department.
SQL Server 2000-person Edition
For mobile users who sometimes disconnect from the network, but the applications they run require SQL Server data storage
。 Personal editions are also used when running stand-alone applications that require local SQL Server data storage on a client computer.
SQL Server 2000 Development Edition
For programmers to develop applications that use SQL Server 2000 as a data store. Although the development version supports the Enterprise version of the
Features enable developers to write and test applications that can use these features, but only develop the version as a development and test system
Used and cannot be used as a production server.
SQL Server Windows CE Edition
Use the Microsoft®sql server 2000™WINDOWS®CE version (SQL Server
CE) on the Windows CE device for data storage. Can replicate in any version of SQL Server 2000
To keep Windows CE data synchronized with the primary database.
SQL Server 2000 Enterprise Evaluation Edition
A full-featured version that can be downloaded free of charge from the Web. For evaluating SQL Server functionality only; 120 days after download
This version will stop running.
These SQL Server 2000 versions also include allowing application developers to distribute SQL server with their applications
2000 copy of the relational data flow engine. This component includes two names:
SQL Server 2000 Desktop Engine
Microsoft Data Engine (MSDE) 2000
SQL Server Books Online calls this component the Desktop Engine. Information about the Desktop Engine also applies to MSDE 2000.
Because the functionality of the database engine in the SQL Server 2000 Desktop Engine is linked to the database in each version of SQL Server
The engine has similar functions, so the desktop engines cannot be larger than 2 GB.
The SQL Server 2000 desktop and SQL Server 2000 editions have a concurrent workload governor that can
Restricts the performance of the database engine when more than 5 batches are executed concurrently. For more information about the concurrency workload governor,
See SQL Server 2000 database on the desktop.
Here is a list of some of the relevant comparisons in the online Help, as a reference
current 1/3 page
1 23 Next read the full text
