How to Determine SQL Version and Edition

To determine what SQL version and edition you have, connect to the instance of SQL Server, and then run the following query:


SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Also, see here to determine the common name for the version you have: http://sqlserverbuilds.blogspot.co.nz/

Props to the team and community that keep that site updated.

Reference:
http://support.microsoft.com/kb/321185
http://sqlserverbuilds.blogspot.co.nz/