Capturing the Edition of Currently Running SQL Server

Capturing the Edition of Currently Running SQL Server 

In this blog we see, How to Capture the Edition of Currently Running SQL Server

 

1.       Installed product edition of the instance of SQL Server.

2.       Use the value of this property to determine the features and the limits.

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:

SELECT SERVERPROPERTY('EDITION')

 

Base data type: 

nvarchar(128)

 

OUTPUT: It is based on your SQL server installed

Standard Edition (64-bit)