Features Supported by the Editions of SQL Server 2000

This topic summarizes the features that the different editions of Microsoft® SQL Server™ 2000 support.

For more information about the amount of physical memory SQL Server 2000 can address, and the number of CPUs each edition supports in symmetric multiprocessor (SMP) computers, see Maximum Capacity Specifications.

Database Engine Features Supported by the Editions of SQL Server 2000

This table shows the database engine features and the editions of SQL Server 2000 that support them.


Database Engine Feature


Enterprise Edition


Standard Edition


Personal Edition


Developer Edition


Desktop Engine


SQL Server CE

Enterprise Evaluation Edition

Multiple Instance Support

Supported

Supported

Supported

Supported

Supported

N/A

Supported

Failover Clustering (up to four nodes)

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Failover Support in SQL Server Enterprise Manager

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Log Shipping

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Parallel DBCC

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Parallel CREATE INDEX

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Enhanced Read-ahead and Scan

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Indexed Views

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Federated Database Server

Supported

N/A

N/A

Supported

N/A

N/A

Supported

System Area Network (SAN) Support

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Graphical DBA and Developer Utilities, Wizards

Supported

Supported

Supported

Supported

N/A

N/A

Supported

Graphical Utilities Support for Language Settings

Supported

N/A

N/A

N/A

N/A

N/A

N/A

Full-Text Search

Supported

Supported

Supported (except on Windows 98)

Supported

N/A

N/A

Supported

 

Replication Features Supported by the Editions of SQL Server 2000

This table shows the replication features and the editions of SQL Server 2000 that support them.


Replication Publisher Feature



Enterprise Edition



Standard Edition



Personal Edition



Developer Edition



Desktop Engine



SQL Server CE

Enterprise Evaluation Edition

Snapshot Replication

Supported

Supported

Supported

Supported

Supported

N/A

Supported

Transactional Replication

Supported

Supported

Subscriber only

Supported

Subscriber only

N/A

Supported

Merge Replication

Supported

Supported

Supported

Supported

Supported

Anonymous Subscriber only

Supported

Immediate Updating Subscriptions

Supported

Supported

Supported

Supported

Supported

N/A

Supported

Queued Updating Subscribers

Supported

Supported

Supported

Supported

Supported

N/A

Supported

 

Analysis Services Features Supported by the Editions of SQL Server 2000

This table shows the Analysis Services features and the editions of SQL Server 2000 that support them.



Analysis Services Feature




Enterprise Edition



Standard Edition



Personal Edition



Developer Edition



Desktop Engine



SQL Server CE

Enterprise Evaluation Edition

Analysis Services

Supported

Supported

Supported

Supported

N/A

N/A

Supported

User-defined OLAP Partitions

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Partition Wizard

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Linked OLAP Cubes

Supported

N/A

N/A

Supported

N/A

N/A

Supported

ROLAP Dimension Support

Supported

N/A

N/A

Supported

N/A

N/A

Supported

HTTP Internet Support

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Custom Rollups

Supported

Supported

Supported

Supported

N/A

N/A

Supported

Calculated Cells

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Writeback to Dimensions

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Very Large Dimension Support

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Actions

Supported

Supported

Supported

Supported

N/A

N/A

Supported

Real-time OLAP

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Distributed Partitioned Cubes

Supported

N/A

N/A

Supported

N/A

N/A

Supported

Data Mining

Supported

Supported

Supported

Supported

N/A

N/A

Supported

 

Data Transformation and Decision Support Query Features Supported by the Editions of SQL Server 2000

This table shows the data transformation and decision support query features and the editions of SQL Server 2000 that support them.



Analysis Services Feature



Enterprise Edition



Standard Edition



Personal Edition



Developer Edition



Desktop Engine



SQL Server CE

Enterprise Evaluation Edition

Data Transformation Services

Supported

Supported

Supported

Supported

Deployment only

N/A

Supported

Integrated Data Mining

Supported

Supported

Supported

Supported

N/A

N/A

Supported

English Query

Supported

Supported

Supported

Supported

N/A

N/A

Supported



©1988-2000 Microsoft Corporation. All Rights Reserved.