SQL Server 2000 Editions FAQs
Home

Q1: What are the different versions of SQL Server 2000?

1)Enterprise Edition
2)Standard Edition
3)Personal Edition
4)Developer Edition
5)Windows CE Edition
6)Desktop Edition (MSDE)
7)Evaluation Edition

Q2: Tell me more about the Enterprise Edition?

This edition is comprehensive: it includes the complete set of SQL Server database and analysis features and is uniquely characterized by several features that make it the most scalable and available edition of SQL Server 2000. It scales to the performance levels required to support the largest Web sites and enterprise online transaction processing (OLTP) and data warehousing systems. Its support for failover clustering also makes it ideal for any mission critical line-of-business application. Additionally, this edition includes several advanced analysis features that are not included in SQL Server 2000 Standard Edition.
There are four main areas in which the additional features of SQL Server 2000 Enterprise Edition are most evident:
Scalability
Availability/uptime
Performance
Advanced analysis

Q3: Tell me more about the Standard Edition?

This is a more affordable option for small-sized and medium-sized organizations that do not require the advanced scalability, availability, performance, or analysis features of SQL Server 2000 Enterprise Edition. Standard Edition can be used on symmetric multiprocessing systems with up to 4 CPUs and 2 GB of RAM.
Standard Edition includes the core functionality needed for non-mission-critical e-commerce, data warehousing, and line-of-business solutions. For instance, all of the XML features present in Enterprise Edition are also included in Standard Edition. And while a handful of advanced OLAP features are reserved for Enterprise Edition, all data mining features and the core OLAP functionality are included in SQL Server 2000 Analysis Services in Standard Edition. Similarly, components that other database vendors charge for as separate add-on products for their highest-end editions are included in Standard Edition:

1)Data Transformation Services (DTS)
2)Replication (snapshot, transactional, and merge)
3)Full-Text Search
4)English Query
5)Stored procedure development and debugging tools
6)SQL Profiling and performance analysis tools

Q4: Tell me more about the Personal Edition?

Ideal for mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage, and for stand-alone applications that require local SQL Server data storage on a client computer.

Q5: Tell me more about the Developer Edition?

The ideal choice for Independent Software Vendors (ISVs), consultants, system integrators, solution providers, and corporate developers developing and testing applications because it is cost effective, runs on a variety of platforms, and can be upgraded for production use to SQL Server 2000 Enterprise Edition.
The Developer Edition licensee also has the right to redistribute SQL Server CE-based applications to an unlimited number of devices at no additional cost beyond the purchase price of SQL Server 2000 Developer Edition. Devices running SQL Server CE that access or otherwise use the resources of a SQL Server must be properly licensed.

Q6: Tell me more about the SQL Server Windows CE Edition?

The compact database for rapidly developing applications that extend enterprise data management capabilities to devices. SQL Server CE is a full-fledged member of the SQL Server 2000 family, with tools, application programming interfaces (APIs), and SQL grammar that developers and database administrators with existing SQL Server skills will recognize. SQL Server CE is the only edition of SQL Server 2000 that provides relational database management capabilities on Windows CE-based devices.

Q7: Tell me more about the SQL Server Desktop Edition (MSDE)?

The successor to MS Data Engine (MSDE) 1.0, which was based on SQL Server version 7.0. As such, SQL Server 2000 Desktop Engine is often referred to as MSDE 2000. The SQL Server 2000 Desktop Engine is not related to SQL Server 7.0 Desktop Edition.
Probably the most significant characteristic of the Desktop Engine is that it is a redistributable version of the SQL Server relational database engine. Third-party software developers can include it in their applications that use SQL Server to store data. The SQL Server 2000 Desktop Engine is made available as a set of Windows Installer merge modules that can be included in the application setup. The Desktop Engine is an ideal embedded or offline data store, because it is easy to install and has the smallest footprint of any edition of SQL Server 2000.

Q8: Tell me more about the SQL Server Evaluation Edition?

SQL Server 2000 Evaluation Edition (also known as SQL Server 2000 Enterprise Evaluation Edition) is a time-limited version of SQL Server 2000 Enterprise Edition that is licensed for demonstration, testing, examination, and evaluation for a period of 120 days. This means that Evaluation Edition is not for production use; solutions must be deployed on SQL Server 2000 Enterprise or Standard Edition. Evaluation Edition will not function after the 120-day limit has been reached. The only cost for this edition is a minimal shipping and handling fee. The advantage of the Evaluation Edition is that you can evaluate the complete set of features in SQL Server 2000, which can be useful whether you are already familiar with SQL Server or are completely new to the product.

Home