SQL Server 2008 Editions & Difference
- Enterprise Edition
- Standard Edition
- Workgroup Edition
- Web Edition
- Compact Edition
It supports a subset of the standard data types, does not support stored procedures or Views or multiple-statement batches (among other limitations). It is limited to 4 GB maximum database size and cannot be run as a Windows service, Compact Edition must be hosted by the application using it. The 3.5 version includes considerable work that supports ADO.NET Synchronization Services
- Express Edition
- SQL Server 2008 Express Edition.
- SQL Server 2008 Express with Tools.
- SQL Server 2008 Express with Advanced Tools.
More info