| 437-991-3573 | Data Tier Services
Explore Tools
Experts in Microsoft SQL Server, Clusters, Always On, Migrations, ERP, Performance & Cloud

List SQL Server Non-Default Configuration Options
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)

Using Management Studio, you can get a list of Non-Default Configuration settings that have been set for your SQL Server Instance.

In Management Studio, navigate to Object Explorer, right-click on the Instance name, select Report, select Server Dashboard.

Within this report, navigate to the section titled "Non Default Configuration Options".