Get SQL Server Version/Edition Information

Just connect to the database in which you are interested, open a new query window, and enter the following query:

[sourcecode language="sql"]
SELECT SERVERPROPERTY('ProductVersion') as 'Product Version',
SERVERPROPERTY('ProductLevel') as 'Product Level',
SERVERPROPERTY('Edition') as 'Edition'
[/sourcecode]

For me, this produced the following:

Product Version  Product Level  Edition
10.50.1600.1     RTM            Enterprise Edition (64-bit)