How to identify SQL Server version and edition

This comes in handy when you need to check the SQL Server Version, Service Pack which your Enterprise is running, It shows the different versions and sp's for SQL Server rite from version 6.5 to SQL Server 2008, A handy link to be stored in your favorites and this is the query :

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

You can read more here,

http://support.microsoft.com/kb/321185