Compare SQL Server 2005 Editions

With the release of SQL Server 2005, Microsoft has introduced the Express edition and the Workgroup edition to better meet the needs of each customer. The new line of SQL Server 2005 editions includes Express, Workgroup, Standard, and Enterprise Edition. The four new editions will offer a range of features including high availability, scalability, and business intelligence tools. The following table lists the various features in each edition:

Express Workgroup Standard Enterprise
Number of CPUs 1 2 4 No Limit
RAM 1 GB 3 GB No Limit No Limit
Database Size 4 GB No Limit No Limit No Limit
Merge Replication
Transactional Replication
Report Server
Management Studio
Report Builder
Backup Log-shipping
Full Text Search
SQL Agent Job Scheduling
Database Mirroring
Failover Clustering
Notification Services
Integration Services
Web Services (HTTP Endpoints)
Analysis Services
Data Mining
Database Tuning Advisor
Advanced Performance Tuning

 

Read more about SQL Server 2005 editions and features…