(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.