Quick one today:

More frequently that I would like, we keep getting these questions from customers. “What Sql Server Edition do we have in our production / Development environment?”

There are many easy ways to check, I’ll list a couple here.

Using T-SQL

• @@VERSION variable has complete details.
• SERVERPROPERTY(‘Edition‘) also give you the edition information. Possible values are below:
  • ‘Enterprise Edition’
  • ‘Enterprise Edition: Core-based Licensing’
  • ‘Enterprise Evaluation Edition’
  • ‘Business Intelligence Edition’
  • ‘Developer Edition’
  • ‘Express Edition’
  • ‘Express Edition with Advanced Services’
  • ‘Standard Edition’
  • ‘Web Edition’
  • SQL Database
• Similarly, SERVERPROPERTY(‘EngineEdition‘), gives the same information in INT format. Possible values are below:
  • 1 = Personal or Desktop Engine (Not available in SQL Server 2005 and later versions.)
  • 2 = Standard (This is returned for Standard, Web, and Business Intelligence.)
  • 3 = Enterprise (This is returned for Evaluation, Developer, and both Enterprise editions.)
  • 4 = Express (This is returned for Express, Express with Tools and Express with Advanced Services)
  • 5 = SQL Database

Sql Server Edition Result

Using SSMS

Go to SSMS, right click on the Sql Server Instance and go to properties. See below:

Sql Server Edition

Hope this helps,

_Sqltimes