How can i tell what SQL Server features and version do I have installed? This question has been asked a lot recently.  Starting in SQL Server 2008, we added a SQL Server discovery report as an option on the Tools page on the Installation Center.  When you click on the link below, SQL Server will be started to discover the SQL Server features.

The Installation Center can be launched from the Start Menu, under the SQL Server 2008 entry:

image

 

Click on the “Installed SQL Server features discovery report”

image

 

Here is the report:

image

The SQL Server Discovery Report is saved to %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\<last Setup Session>

Options:

  • You can also generate the Discovery report through the command line. Run “Setup.exe /Action=RunDiscovery” from a command prompt
  • If you add “/q” to the command line above no UI will be shown, but the report will still be created in %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\20091112_082147.