How can I check what all SQL server features and version are installed on my Machine ?
It’s a frequently asked question. You need to study your environment, need to login each instance to check version & other details, to answer this question.
Till SQL Server 2005, you have no direct solution.
But Starting from SQL Server 2008, Microsoft added a SQL Server discovery report as an useful tool under Tools page of Installation Center.
SQL Server Discovery tool
Lunch SQL Server Installation Center under Configuration Tools ( Click on the Start menu, go to All Programs, click to Microsoft SQL Server <Version Name>, under Configuration Tools click on SQL Server Installation Center) OR Directly Run Setup.exe & browse to Tools Page
Report will be generate & open in default browser automatically
The SQL Server Discovery Report will be saved automatically in %ProgramFiles%Microsoft SQL Server100Setup BootstrapLog<last Setup Session>
Other Useful 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 saved in %ProgramFiles%Microsoft SQL Server100Setup BootstrapLog<last Setup Session>
· SQL Server discovery tool cannot be used to discover Remote SQL server installation