SELECT @@servername 'Server Name',

substring(@@version,1,charindex('-',@@version)-1)

+convert(varchar(100),SERVERPROPERTY('edition'))+ ' '+

+convert(varchar(100),SERVERPROPERTY('productlevel'))'Server Version',

substring(@@version,charindex('-',@@version)+1,(charindex(')',@@version)+1)-charindex('-',@@version)) 'Version Number'

This will provide you with the version name and number of the database server.