Categories
How-To Software Technical

Identify Microsoft SQL Server version & edition

I wanted to determine which version of Microsoft SQL Server 2008 was running on one of my servers. So I opened up SQL Server Management Studio (SSMS), and ran the following command as a new query window:

SELECT SERVERPROPERTY (‘productversion’),
SERVERPROPERTY (‘productlevel’),
SERVERPROPERTY (‘edition’)

The following results are returned:
-The product version (for example, 10.0.1600.22)
-The product level (for example, RTM)
-The edition (for example, Standard Edition 64-bit)