About Us   SSWUG Articles   Articles   FAQ   Administration   Backup/Restore   Connectivity   Development   General   Installation   OLAP   Replication   Transfer/move   Trouble   SQL 6.5   Scripts   Tips   Test Exams   Advertise   Download   History   Search   Traffic   Related Links         Add to Favorites

How many SQL 2000 editions exist and what is the difference between them? Answer: SQL Server 2000 has the following editions: Personal Edition Standard Edition Enterprise Edition Developer Edition Desktop Engine SQL Server CE Evaluation Edition Personal Edition can work on the Windows 98, Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Workstation 4.0 with Service Pack 5 or later and on the all editions of Windows 2000. This edition is related to SQL Server 7.0 Desktop Edition. This edition has some restrictions: maximum 2 CPU no Distributed Partitioned Views no Log Shipping no Parallel DBCC no Parallel index creation no Failover clustering no publishing for transaction replication maximum 2Gb RAM Standard Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter. This edition has the following restrictions: maximum 4 CPU (up to 8 CPU on the Windows NT Enterprise Edition) no Distributed Partitioned Views no Log Shipping no Parallel index creation no Failover clustering maximum 2Gb RAM Enterprise Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter. This edition can use: up to 32 CPU on the Windows 2000 DataCenter up to 8 CPU on the Windows 2000 Advanced Server and on the Windows NT Server 4.0 Enterprise Edition up to 4 CPU on the Windows NT Server 4.0 and on the Windows 2000 Server up to 64Gb RAM on the Windows 2000 DataCenter up to 8 Gb RAM on the Windows 2000 Advanced Server up to 4 Gb RAM on the Windows 2000 Server up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition up to 2 Gb RAM on the Windows NT Server 4.0 Distributed Partitioned Views Log Shipping Parallel index creation Failover clustering The Developer Edition can be used by developers to create and debug stored procedures and triggers. This edition comes with its own compact disc and can be upgraded to SQL Server 2000 Enterprise Edition. The Desktop Engine has no graphical user interface and is related to the MSDE, not to the SQL Server 7.0 Desktop Edition. The size of Desktop Engine databases cannot exceed 2 GB. The Desktop Engine can use maximum 2 CPU. The SQL Server CE edition can work only on the Microsoft Windows CE, so it has all restrictions of this operation system (can use only 1 CPU, no Parallel index creation, no Full-Text Search and so on). The Evaluation Edition can be used only for the test purposes to learn more about the new features and enhancements and should be uninstalled after a 120-day evaluation period. See this article for more details: SQL Server 2000 Installation

Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators. (c) 1997, 2005 Bits on the Wire, Inc