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 |