Home > Articles > SQL Server Administration > Compare SQL Server 2005 Editions

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    See Teratrax Database Manager
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...