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.