SQL Server Engine Edition

(Note: Posting this again for a test)

Hi Friends, Many of already know about different techniques to find out the edition of SQL Server that you are running. The simplest of all has been:

select SERVERPROPERTY (‘edition’)

However, there are 2 more server properties that I want to show you today which might be useful. Run the following code snippet and observe the output:

select SERVERPROPERTY (‘edition’)
select SERVERPROPERTY (‘EngineEdition’)
select SERVERPROPERTY (‘EditionID’)

The output on my machine is as follows:

SERVERPROPERTY (‘edition’) gives me “Developer Edition (64-bit)” – possible values could be:

‘Developer Edition’

‘Enterprise Edition’

‘Enterprise Evaluation Edition’

‘Standard Edition’

‘Express Edition’

‘Express Edition with Advanced Services’

‘Workgroup Edition’

   

‘Windows Embedded SQL’

SERVERPROPERTY (‘EngineEdition’) gives me 3 – possible values could be:

2 = Standard (This is returned for Standard and Workgroup.)

3 = Enterprise (This is returned for Enterprise, Enterprise Evaluation, and Developer.)

4 = Express (This is returned for Express, Express with Advanced Services, and Windows Embedded SQL.)

SERVERPROPERTY (‘EditionID’) gives me –2117995310 – possible values could be:

-1592396055 = Express

-1534726760 = Standard

1333529388 = Workgroup

1804890536 = Enterprise

-323382091 = Personal

-2117995310 = Developer

610778273 = Enterprise Evaluation

1044790755 = Windows Embedded SQL

4161255391 = Express with Advanced Services

So, you can see that you have various properties to find out the exact edition & exact feature set of an installed edition on the box.

 

 

   

About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: http://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

View all posts by Amit Bansal →

Leave a Reply

Your email address will not be published.