sqlcmd -S %computername% -E -Q "SET NOCOUNT ON SELECT ltrim(rtrim(convert(varchar, SERVERPROPERTY('productversion')))) AS Build, ltrim(rtrim(convert(varchar, SERVERPROPERTY ('productlevel')))) AS ProductLevel, ltrim(rtrim(convert(varchar, SERVERPROPERTY ('edition')))) AS Edition, @@Version AS [@@Version]" -s ";"
says I have SQL Server Express 2008 R2 installed, SP1 included:
Build ;ProductLevel ;Edition
;@@Version
------------------------------;------------------------------;------------------
------------;-------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------------------------------
10.50.1600.1 ;RT ...
Go to the complete details ...