Tuesday, August 21, 2012

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.

No comments:

Post a Comment