Friday, March 26, 2010

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.

No comments: