Table 14. Comparing features of SQL Server 7.0 and MSDE 1.0
| Feature | SQL Server 7.0 Enterprise Edition |
SQL Server 7.0 Standard Edition |
SQL Server 7.0 Desktop Edition |
MSDE 1.0 |
| General (depends upon hardware platform and application requirements) | ||||
| Theoretical Maximum Database Size |
Unlimited | Unlimited | Unlimited | 2 GB per database |
| Theoretical Maximum Number of Concurrent Users | 32,767 | 32,767 | 5 | 5 |
| Theoretical Maximum Number of Processors | 32 | 4 | 2 | 1 |
| Database Architecture | ||||
| Client/Server Architecture | Yes | Yes | Yes | Yes |
| Transactions and Recovery | Yes | Yes | Yes | Yes |
| Concurrency Control (Dynamic Locking) | Yes | Yes | Yes | Yes |
| High Availability | Yes | Yes | Yes | Yes |
| Database Server Fail Over | Yes | No | No | No |
| Online Backup | Yes | Yes | Yes | Yes |
| Automatic Configuration and Tuning | Yes | Yes | Yes | Yes |
| Automatic Disk Space Allocation | Yes | Yes | Yes | Yes |
| Cost-Based Query Optimization | Yes | Yes | Yes | Yes |
| Server-Enforced Data Integrity | Yes | Yes | Yes | Yes |
| Database Management and Administration | ||||
| SQL Server Enterprise Manager | Yes | Yes | Yes | No |
| Database Maintenance Wizard | Yes | Yes | Yes | No |
| SQL Server Distributed Management Objects | Yes | Yes | Yes | Yes |
| SQL Namespace | Yes | Yes | Yes | No |
| SQL Server Agent | Yes | Yes | Yes | No |
| SQL Server Profiler and Index Tuning Wizard | Yes | Yes | Yes | No |
| Database Upgrade Wizard | Yes | Yes | Yes | No |
| Distributed Database Services | ||||
| Distributed Query Processing | Yes | Yes | Yes | Yes |
| Distributed Transactions | Yes | Yes | Yes | Yes |
| Snapshot Replication | Yes | Yes | Yes | Yes |
| Transactional Replication | Yes | Yes | Yes | Subscriber Only |
| Updating Subscribers | Yes | Yes | Yes | Yes |
| Merge Replication | Yes | Yes | Yes | Yes |
| Data Transformation Services | Yes | Yes | Yes | Yes |
| Import and Export Wizards | Yes | Yes | Yes | No |
| Decision-Support Services | ||||
| Extraction, Transformation and Loading | Yes | Yes | Yes | Yes |
| Advanced Join Techniques | Yes | Yes | Yes | Yes |
| Bulk Update Processing | Yes | Yes | Yes | Yes |
| Data Partitioning | Yes | Yes | Yes | Yes |
| Parallel Query Processing | Yes | Yes | No | No |
| 64-Bit Memory Addressing | Yes | No | No | No |
| Natural Language Query Processing | Yes | Yes | Yes | No |
| Multidimensional Analysis | Yes | Yes | Yes | No |
| Metadata Services | Yes | Yes | Yes | No |
| Application Development | ||||
| OLE DB / ADO | Yes | Yes | Yes | Yes |
| ODBC | Yes | Yes | Yes | Yes |
| DB-Library | Yes | Yes | Yes | Yes (see Endnote 9) |
| Transact-SQL | Yes | Yes | Yes | Yes |
| N-Tiered Applications | Yes | Yes | Yes | Yes |
| Web Applications | Yes | Yes | Yes | Yes |
| SQL Server Web Assistant | Yes | Yes | Yes | No |
| Microsoft BackOffice Integration | ||||
| Windows NT Server Integration | Yes | Yes | Yes | Yes |
| Exchange Server Integration | Yes | Yes | Yes | No |
| SNA Server Integration | Yes | Yes | Yes | Yes |
| Proxy Server Integration | Yes | Yes | Yes | Yes |
| Site Server Integration | Yes | Yes | Yes | Yes |
| Systems Management Server Integration | Yes | Yes | Yes | Yes |