Description

This article describe steps to check SQL version using SQL Management Studio.


How to find SQL Server Version,Edition,Server Name?
SQL Server provides a System Defined function SERVERPROPERTY(propertyname) .

By using this function you can find a number of things



Detail Steps

  1. In the SQL Management Studio, run the query below:
    select serverproperty('EditionID')
  2. Check the result and the following is the version:
    -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

Note: Express version is free, while others are paid.


Property Name

Description

syntax

Edition

Return SQL Server edition installed on machine.

select ServerProperty('edition')

EditionID

return Edition ID

select ServerProperty('editionid')

InstanceName

Return instance name if it is not default.In case of default return Null.

select ServerProperty('InstanceName')

ProductVersion

return Product version

select ServerProperty('ProductVersion')

BuildClrVersion

return version of the .NET framework Common Language Runtime (CLR)

select ServerProperty('BuildClrVersion')

EngineEdition

return

1 = Desktop

2 = Standard

3 = Enterprise

4 = Express

5 = SQL Azure

select ServerProperty('EngineEdition')

IsClustered

Server instance is configured in a failover cluster.

1 = Clustered.

0 = Not Clustered.

NULL = Input is not valid, or an error.

select ServerProperty('IsClustered')

MachineName

Return machine name

select ServerProperty('MachineName')

ResourceLastUpdateDateTime

Returns the date and time that the Resource database was last updated

select ServerProperty('ResourceLastUpdateDateTime')

ProductLevel

Returns Level of the version of SQL Server instance

'RTM' = Original release version

'SPn' = Service pack version

'CTP', = Community Technology Preview version

select ServerProperty('ProductLevel')













Related Information

None