SQL Server: Query Server Name, Edition, Product Level, Product Version

Run this query for the SQL Server name, edition, product level, and product version:

SELECT
SERVERPROPERTY('SERVERNAME') AS 'Server Name',
SERVERPROPERTY('EDITION') AS 'Edition',
SERVERPROPERTY('PRODUCTLEVEL') AS 'Product Level',
SERVERPROPERTY('PRODUCTVERSION') AS 'Product Version'

Refer to Microsoft KB 321185 titled, "How to identify your SQL Server version and edition" to identify which service pack corresponds with the product version number.