Please wait, loading...

 

Find Microsoft SQL Server Details ( Edition , version , EditionID , etc)

September 1, 2015
There are several Methods to get Edition of Microsoft SQL Server or any other details But moat common is Hitting SQL Query :

“select serverproperty(‘Edition’)”

OR get Edition Id which can be used in others process .
“select serverproperty(‘EditionID’)”
Below are the ID 
-1253826760 = Desktop
-1592396055 = Express
-1534726760 = Standard
1333529388 = Workgroup
1804890536 = Enterprise
-323382091 = Personal
-2117995310 = Developer
610778273 = Enterprise Evaluation
1044790755 = Windows Embedded SQL
4161255391 = Express with Advanced Services
Thanks Hope this Helped you for any query please comment below.


SOURCE : JUST2CODE.IN Subscribe to our YouTube channel : https://www.youtube.com/user/TheRussell2012

https://i0.wp.com/microsoftdynamics.in/wp-content/uploads/2020/04/Microsoftdynamics365.png?fit=640%2C651
Microsoft Dynamics Community Profile

Learn more