How to Check SQL Server Version

If you would like to know/check SQL Server version that is currently being used in your server Check SQL Server Version then the easiest way is using the below query:

SELECT @@VERSION

The above query when executed in SQL Server Management Studio will return something as shown below:

Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

But the information is returned as a single string, so if you would like get the individual properties then you can use the SQL Server built-in function.

Check SQL Server Version using Built-in-function

If you are looking for some fine-tuned results based on which you could modify the output then you can make use of the Built-in-function called SERVERPROPERTY.

Syntax:

SERVERPROPERTY (propertyname)

There are various properties available but let us make use of those that helps us to find the SQL Server version.

 

So based on the above parameters you could frame your own query as shown below,

SELECT SERVERPROPERTY(‘PRODUCTVERSION’) as VersionNumber, SERVERPROPERTY (‘PRODUCTLEVEL’)as ProductLevel, SERVERPROPERTY (‘EDITION’) as Edition

Which will give you the below result:

10.50.1600.1       RTM       Enterprise Edition (64-bit)

SQL Server Product Version Reference:

You can use the below table as a reference to check which SQL Server Release is installed in your server for the respective Product Version. For example: Version 10.50.1600.1  means SQL Server 2008 R2 RTM is the SQL Server Release installed on the server.