SQL Server 2008 Editions

SQL Server 2008 Editions

SQL Server 2008 is available in the following editions:

Enterprise
Designed for the largest organizations and those needing to leverage the full power of the SQL Server 2008 platform.
Standard Designed for small and midsized organizations that do not need all the capabilities available in SQL Server 2008 Enterprise.

Workgroup
Suitable for small departmental projects with a limited set of features.

Express
A freely redistributable version of SQL Server that is designed to handle
the needs of embedded applications as well as the basic data storage needs for server-based applications, such as Web applications with a small number of users.

Compact
Designed as an embedded database.

Developer
Designed for use by developers in creating SQL Server applications.
SQL Server 2008 Developer has all the features and capabilities as SQL Server 2008 Enterprise, except that it is not allowed to be used in a production environment.

Evaluation
Designed to allow organizations to evaluate SQL Server 2008. SQL Server 2008 Evaluation has all the features and capabilities as SQL Server 2008 Enterprise,except that it is not allowed to be used in a production environment and it expires after 180 days.