Question of the Day: Know your in-use IIS & SQL server versions?

Ever wonder what versions are in use for IIS and MS SQL server? For server-side development, this can be a common questions that get asked often.

• For IIS, visit the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\InetStp\VersionString

• For MS SQL server:

(1) Connect to the SQL server via the Management Studio tool


(2) Run the query - 


Select @@version


The result is then shown ~
==================================================
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 
10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express 
Edition (64-bit) on Windows NT 6.1 (Build 7600: )
==================================================


BTW, thank goodness it's Friday!