Capturing the Edition based on ID of Currently Running SQL Server

Lajapathy Arun
12y
2k
0
0

Blog

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))