Determine SQL Server version

If you need to determine what version of SQL Server is running just make a new query as follows

select @@version

Then you can look the version number against this Microsoft KB

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