Web Table 1: SQL Server Express and SQL Server 2005 Workgroup Features Comparison
Feature SQL Server Express SQL Server 2005 Workgroup
Management SQL Server 2005 Express Manager for database; Report Manager for reports SQL Server Management Studio for database; Report Manager for reports
Processor limit 1 CPU 2 CPUs
Maximum database size 4GB No practical limit
RAM 1GB 3GB
SQL Server Agent No Yes
High-availability features None Backup log shipping
DTA No Yes
Report Builder No Yes
SQL Server 2005 Reporting Services forms-based (custom) authentication No Yes
Freely redistributable Yes No
ClickOnce deployment Yes No
Application XCopy Yes No
Upgradeable No Yes
SSIS runtime No Yes
Replication Subscriber only Full support