How to find SQL Server Edition and version related information

SQL Server build related info can be retrieved in numbers of ways. Below are the three most popular ways of them:

1. @@Version Function
2. SERVERPROPERTY() Function
3. XP_MSVER extended Stored Procedure

• @@Version Function
The return type of select @@version is nvarchar. It has few other Functions also like:

select @@version
select @@SERVERNAME
select @@SERVICENAME

How to find SQL Server Edition and version related information

• SERVERPROPERTY() Function
This returns property info about the Server Instance. The example below uses Serverproperty function in a select query to return info related to SQL Server  Product Level, Version, Edition along with Server Name and its collation.

SELECT
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('MachineName') AS ServerName,
SERVERPROPERTY('Collation') AS ServerCollation
Go

How to find SQL Server Edition and version related information

•XP_MSVER extended Stored Procedure

This extended stored Procedure returns version information about Microsoft SQL Server. It also returns information about the build number of the server and information about the server environment. This procedure also returns info about OS & Hardware of the server like WindowsVersion, ProcessorCount, ProcessorType, PhysicalMemory etc.

exec xp_msver

How to find SQL Server Edition and version related information

If executed without any Parameter it returns information about all Properties, otherwise the output can be restricted to one parameter info by providing property name as a parameter.

exec xp_msver ProcessorCount

How to find SQL Server Edition and version related information


 

<<Click here to see all posts>>

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Prove You Are Human Time limit is exhausted. Please reload CAPTCHA.