How to find Installed SQL Server Version and Edition

This post describes possible ways to find installed SQL server version and edition. Assume that you are a DBA and you have been given a task to plan for SQL upgrade. The first thought that comes to your mind is “What is the version and edition of my SQL Server”. You might also look for possible upgrade paths for latest SQL versions.

Finding out this information shouldn’t be tough however it is good to know the ways to determine SQL server version and edition. This post should come handy if someone asks what SQL Server version you are running ?. You can use any of the below methods to identify SQL server version. For complete info on SQL versions and build numbers click here.

Find Installed SQL Server Version and Edition

We will look at some of the easiest methods to find installed SQL server versions. Note that these methods should work on almost all recent editions of SQL server.

Method 1 – Using SQL Query to find installed SQL server version

Launch SQL server management studio and login with the credentials. Right click on server and click New Query. In the query box type select @@version and click Execute. The result should look similar to the below output. If you don’t have the creds to login to SQL management studio then check the next method.

Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64) Enterprise Edition (64-bit) on Windows NT 6.3 <X64>

Find Installed SQL Server Version

Method 2 – Determine SQL Server Version using SQL Server Properties

This is probably one of the easiest method to find out SQL server details. In this method we will determine SQL server version through sqlservr properties. Navigate to C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn and look for sqlservr executable. Right click the file and click Properties. Click Details tab, you should find product version and product name listed.

Find Installed SQL Server Version

Method 3 – Find out SQL Server version using SQL Query

In this method we will use the below query to fetch the SQL details. This includes product version, product level and edition.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Find Installed SQL Server Version

You might also like

Leave a Reply

1 Comment threads
1 Thread replies
Most reacted comment
Hottest comment thread
newest oldest most voted
Nico Junge
Nico Junge

ist there a way to report or query the SQL Server Edition in SCCM? I would like to distinguish between Enterprise, Standard and Express Edition.
Thanks in advance!


John McDermott
John McDermott

any new on this? could use it today

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More