SQL Server Architecture
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 |