SQL Server Configuration Options

If you need to review configuration options of some SQL Server instance, you can get them out of the SYS.CONFIGURATIONS catalog view. So the select statement like

select * from sys.configurations

order by name

will give you back all configuration options of SQL Server instance.