The Configuration object represents Microsoft® SQL Server™ engine-configurable parameters and values.
With the Configuration object, you can:
The ShowAdvancedOptions property of the Configuration object controls the membership of the ConfigValues collection. Each ConfigValue object in the collection represents a specific SQL Server configuration option. For more information about advanced options, see Setting Configuration Options.
Some SQL Server configuration options do not take effect until the SQL Server service has been stopped and restarted. You can force the server to immediately accept changes in some options by using the ReconfigureWithOverride method.
To set a configuration option
ReconfigureCurrentValues Method | ReconfigureWithOverride Method |