SQL 2000 Features

This page contains the list of features as they appear in SQL 2000’s Books Online.

Database Engine Features Supported by the Editions of SQL Server 2000
Database Engine Feature Enterprise Edition Standard Edition Personal Edition Developer Edition Desktop Engine (MSDE 2000) 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
SQL Mail Supported Supported Supported Supported N/A N/A Supported

 

Replication Features Supported by the Editions of SQL Server 2000
Replication Publisher Feature Enterprise Edition Standard Edition Personal Edition Developer Edition Desktop Engine (MSDE 2000) 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
Analysis Services Feature Enterprise Edition Standard Edition Personal Edition Developer Edition Desktop Engine (MSDE 2000) 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
Analysis Services Feature Enterprise Edition Standard Edition Personal Edition Developer Edition Desktop Engine (MSDE 2000) 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