How do you find SQL Server version/edition without SSMS installed? How do find out which edition is installed without having the management studio installed?  I have a server that functions as a license manager for another software.  Upon investigation of a high RAM usage alert, I found that the sqlservr.exe process is taking up almost 2 GB of RAM.

I looked through the program menu and found that the configuration manager was installed, otherwise, it is pretty bare bones.  I clicked on properties of the EXE file and found 10.50.1600.1, but there is no place that I've found that states whether it is Express, Dev, STN, ENT, etc.

If I had to guess, this is an express edition, but I wanted to know if there is an obvious tell-tale sign.

Update:
@Bob - The file tells me what I know, not the edition.

@valo - I get the following error when I run that command and I did verify named pipes was enabled:


  HResult 0x35, Level 16, State 1
  Named Pipes Provider: Could not open a connection to SQL Server [53].
  Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance->specific error has occurred while establishing a connection to SQL Server. Server is not >found or not accessible. Check if instance name is correct and if SQL Server is configured >to allow remote connections. For more information see SQL Server Books Online..
  Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.


@thomas - I noticed the Stock Keeping Unit Name before I asked the question, but that seemed too easy, I guess my initial suspicion was correct.
You can try the command line tool:

C:\&gt;sqlcmd -S [SERVER] -d [DB_NAME] -E -Q "SELECT @@VERSION"