How to Identify Your SQL Server Version and Edition

There are several ways to determine the version of SQL Server that is installed.  This article will go over a few of the most common methods to find the current SQL Server version number and the corresponding service pack (SP) level.

Method 1:
Applicable on all versions of SQL Server

Run the following command in Management Studio:

SELECT @@VERSION

Sample results:

Method 2:
Applicable on versions 2000 and up

Run the following command in Management Studio:

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

Sample results:

Method 3: 
Applicable on versions 2005 and up

Run the following command in Management Studio:

EXEC xp_msver

Sample results:

Click here for a complete list of SQL Server versions and build numbers.