How many SQL 7.0 editions exist and what is the difference between them?
There are three SQL Server 7.0 editions: • Desktop Edition • Standard Edition • Enterprise Edition Desktop Edition can be installed on Windows 9x, Windows NT Server/Workstation 4.0 with Service Pack 4, Windows NT Server Enterprise Edition and on the all editions of Windows 2000. This edition has some restrictions: • maximum 2 CPU • no publishing for transaction replication • no SQL Server Failover Support • no Full-text search • maximum 2Gb RAM • maximum 4GB per database Standard Edition can be installed on Windows NT Server 4.0 with Service Pack 4, Windows NT Server Enterprise Edition and on the Windows 2000 Server/Advanced Server/Datacenter. This edition has the following restrictions: • maximum 4 CPU • no SQL Server Failover Support • maximum 2Gb RAM Enterprise Edition can be installed on the Windows NT Server Enterprise Edition and on the Windows 2000 Advanced Server/Datacenter. This edition can use up to 32 CPU and more than 2Gb RAM, it also supports Full-text search and SQL Serve
