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)