The following table specifies the maximum memory support for each edition of SQL Server 2008.
Enterprise
Operating system maximum
Developer
Standard
Web
Workgroup
4 GB (64-bit), OS maximum (32-bit)
Express
1 GB
Express with Tools
Express with Advanced Services