Capturing the Edition based on ID of Currently Running SQL Server
In this blog we see, How to Capture the Edition based on ID 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. 64-bit versions of the Database Engine append (64-bit) to the version.
Overall List of Edition of SQL Server
1804890536 = Enterprise
1872460670 = Enterprise
Edition: Core-based Licensing
610778273= Enterprise
Evaluation
284895786 = Business
Intelligence
-2117995310 = Developer
-1592396055 = Express
-133711905= Express with
Advanced Services
-1534726760 = Standard
1293598313 = Web
Syntax:
SERVERPROPERTY ( propertyname )
Usage:
SELECT SERVERPROPERTY('EDITIONID')
Base data type:
bigint
OUTPUT: It is based on your SQL server installed
-1534726760 (Standard Edition (64-bit))
Join the conversation! Your thoughts help the community grow.