Enterprise Edition – This edition is the complete edition of SQL Server. It is designed for large mission-critical applications including support for Distributed Partitioned Views, log shipping, fail over clustering, and advanced analysis (OLAP) features. Enterprise Edition can take advantage of up to 32 processors and 64GB of RAM (using Address Windowing Extensions, AWE). The maximum database size is 1,048,516 TB.
Standard Edition – This edition is designed for small to medium-sized businesses that do not require the scalability, availability, or the more advanced features of Enterprise Edition. SQL Server 2000 Standard Edition supports up to 4 processors and 2 GB of RAM. The maximum database size is 1,048,516 TB.
Professional Edition – This edition is based on Standard Edition but is optimized for personal use. Unlike Standard Edition, Professional Edition will run on Windows 2000 Professional, Windows NT Workstation 4.0, Windows ME, and Windows 98. Dual processors are supported, but the server is limited to 5 concurrent connections and a maximum database size of 2 GB.
Developer Edition – Same as Enterprise Edition but it has a licensing restriction that it cannot be used in a production environment.
Enterprise Evaluation Edition – Same as Enterprise Edition but is licensed for “demonstration, testing, examination and evaluation” and has a 120-day time limit.
Windows CE Edition – This edition is designed to run on devices that use Windows CE.
Desktop Engine (MSDE) – This edition (Microsoft calls it an “edition”) is only the database engine of SQL Server 2000. There are no graphical tools provided and the database size and workload are limited. However, this edition has the smallest footprint of all the editions of SQL server.