Determine SQL Server Features And Configurations

Aim: Determine which SQL Server Features are installed and configuration settings.

To determine which features are installed on a server, run the Discovery Report which is available on SQL Server 2008 onwards.

Navigate to the SQL Server Configuration Tools folder in the Windows Start menu and launch the Installation Centre.

In Tools, click Installed SQL Server features discovery report to launch the Discovery Report.

The Discovery Report will show installed features, editions, versions & other information.

A copy of the report can also be found in the SQL Server Program Files folder, e.g. C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<yyyymmdd_hhmmss>.

---

To find further configuration information for an particular instance, run the following query:

SELECT *
FROM sys.configurations;

The details and default configuration settings can be found at https://msdn.microsoft.com/en-us/library/ms188345(v=sql.105).aspx.