Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How many SQL 2000 editions exist and what is the difference between them?

April 26, 2017difference editions exist sql

0

Posted

How many SQL 2000 editions exist and what is the difference between them?

1 Answer

0

Posted

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 Lo