SERVERPROPERTY: What edition do i have?

 Comment: This is a post i am porting from another blog! An old note.

We can verify what edition we are running with the following query

SELECT SERVERPROPERTY('Edition');

My server returns this result.

Standard Edition (64-bit)

Another property that we can inspect is EngineEdition

EngineEdition returns a number

4 = SQLServer Express/SqlServer Express with Adavnced Services/Windows Embedded SQL
3 = SQLServer Enterprise/Enterprise Evaluation/Developer
2 = SQLServer Standard/Workgroup

So,

SELECT SERVERPROPERTY('EngineEdition');

Since i standard result, the result for my query is a 2.

A complete list of what you can find out with SERVERPROPERTY can be found on Books Online. Just place your cursor in the Query Editor window and press F1 for help.

SQLServer 2008:
http://msdn.microsoft.com/en-us/library/ms174396.aspx

SQLServer 2005:
http://msdn.microsoft.com/en-us/library/ms174396%28v=SQL.90%29.aspx