Export (0) Print
Expand All
20 out of 31 rated this helpful - Rate this topic

Editions of SQL Server 2000

SQL Server 2000

  Topic last updated -- January 2004

Microsoft® SQL Server™ 2000 is available in these editions:

SQL Server 2000 Enterprise Edition

Used as a production database server. Supports all features available in SQL Server 2000, and scales to the performance levels required to support the largest 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 Personal Edition

Used by mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage. Also used when running a stand-alone application that requires local SQL Server data storage on a client computer.

SQL Server 2000 Developer Edition

Used by programmers developing applications that use SQL Server 2000 as their data store. Although the Developer Edition supports all the features of the Enterprise Edition that allow developers to write and test applications that can use the features, the Developer Edition is licensed for use only as a development and test system, not a production server.

SQL Server 2000 Windows CE Edition

Microsoft® SQL Server 2000™ Windows® CE Edition (SQL Server CE) is used as the data store on Windows CE devices. Capable of replicating data with any edition of SQL Server 2000 to keep Windows CE data synchronized with the primary database.

SQL Server 2000 Enterprise Evaluation Edition

Full-featured version available by a free download from the Web. Intended only for use in evaluating the features of SQL Server; this version will stop running 120 days after downloading.

These editions of SQL Server 2000 also include a component that allows application developers to distribute a copy of the SQL Server 2000 relational database engine with their applications. This component is named SQL Server 2000 Desktop Engine (MSDE 2000). For more information, see Understanding SQL Server 2000 Desktop Engine (MSDE 2000).

While functionality of the database engine in the SQL Server 2000 Desktop Engine is similar to the database engine in the SQL Server Editions, the size of Desktop Engine databases cannot exceed 2 GB.

Both the SQL Server 2000 Personal Edition and SQL Server 2000 Desktop Engine have a concurrent workload governor that limits the performance of the database engine when more than 5 batches are executed concurrently. For more information about the concurrent workload governor, see The SQL Server 2000 Workload Governor.

Upgrading From One Edition to Another

These are the supported upgrade paths between the editions and versions of SQL Server 2000:

  • SQL Server 2000 Personal Edition to either SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition.

  • SQL Server 2000 Standard Edition to SQL Server 2000 Enterprise Edition.

  • SQL Server 2000 Desktop Engine (MSDE 2000) to SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition.

  • SQL Server 2000 Enterprise Evaluation Edition to SQL Server 2000 Enterprise Edition, SQL Server 2000 Standard Edition, SQL Server 2000 Developer Edition, or SQL Server 2000 Personal Edition. SQL Server 2000 Enterprise Evaluation Edition upgrades are not supported in failover clusters.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.