How to identify SQL SERVER version and edition

Run the following command to find the version and edition of SQL SERVER



or


Check this link (http://support.microsoft.com/kb/321185) to find what service pack has been installed.