SQLServer : Whats Installed ?

When you are performing an inventory on unknown servers one of your first questions is, “OK what versions we have installed/running ?”   There are ways in the GUI to obtain this information, but if you want a quick SQL to provide the answer :

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’);

  • 11.0.2100.60 RTM Express Edition (64-bit)
  • 10.0.2531.0 SP1 Enterprise Edition (64-bit)
  • 9.00.3353.00 SP2 Standard Edition

The above are sample results for 2005, 2008 and 2012 for Base, Enterprise and Express.  If a version is 64 bit it will say so, if its 32 bit it won’t mention it.