Capturing the Edition of Currently
Running SQL Server
In this blog we see, How to Capture
the Edition of Currently Running SQL Server
3. 3. 64-bit
versions of the Database Engine append (64-bit) to the version.
Overall List of Edition of SQL Server
'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'
Syntax:
SERVERPROPERTY ( propertyname
)
Usage:
Base data type:
OUTPUT: It is based on your SQL server installed