Understanding the different SQL Server 7.0 versions

To date, Microsoft has released six different versions of SQL Server 7.0. These versions include the Desktop, Standard, and Enterprise Editions, as well as the Developer, Microsoft Developer (MSDE), and Small Business Server Editions. While all of these versions are SQL Server 7.0, there are some key differences. First of all, you can run the Desktop Edition on Windows NT Workstation 4.0, Windows NT Server 4.0, and Windows 9x. The Desktop Edition doesn't support the Microsoft Search Service, OLAP Services, parallel queries, or transaction replication--and it can't be bought on its own. Instead, you must buy either the Standard or the  Enterprise Edition to get the Desktop Edition. You can run the Standard Edition of SQL Server only on Windows NT  Server 4.0 (or later). This version does support such features as the Microsoft Search Service,  OLAP Services, parallel queries, and  transactional replication. It also supports up to 4 CPUs and 2 GB of RAM. In contrast, the Enterprise Edition runs only on Windows NT Server 4.0 Enterprise Edition and upports Microsoft Cluster Server. It also supports all of the features supported in the Standard Edition--plus up to 32 CPUs and more than 2 GB of RAM. 

The Developer Edition of SQL Server is included with Visual Studio for developer use. This version supports a limited number of connections but does include debugging tools. The Microsoft Developer Edition (MSDE) of SQL Server is simply a run-time engine that's included as part of Microsoft Office 2000. Although the MSDE version includes some of the management utilities, it doesn't include all of them. The MSDE was designed for you to distribute as part of an application, not as a stand-alone product. Finally, the Small Business Server Edition is part of Microsoft's mall Business Server.  This version of SQL Server is essentially the same as the Standard Edition but comes hard-coded with a limit of 100 users and a maximum database size of 10 GB. 

height="43"

SQL Index

Main Index