MSSQLCity.Com - All about MS SQL
     
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  
     
Your button logo
Add to Favorites
 
     
 


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

Answer:

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 Server Failover Support.

    See this article for more details:
    SQL Server 7.0 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, 2010 Bits on the Wire, Inc