Export (0) Print
Expand All

Features Supported by the Editions of SQL Server 2000

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 (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

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 (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

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 (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

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 (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

Show:
© 2014 Microsoft