FIND SQL Server Version with SQL Query

 

 

SELECT LTRIM(RIGHT(LEFT(@@VERSION,38),9))
SELECT 'SQL Server '    

+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '    

+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('    

+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

-------------------
Thanks,
http://sccm07.blogspot.com/