The ConfigValue object represents the attributes of a single Microsoft® SQL Server™ configuration option.
Some SQL Server configuration options do not take effect until the SQL Server service (MSSQLServer) has been stopped and restarted. You can force the server to immediately accept changes in some options by using the ReconfigureWithOverride method. The DynamicReconfigure property indicates whether the ConfigValue object requires a restart.
The ConfigValue object contains four value properties. The MinimumValue and MaximumValue properties represent bounds for the given configuration option. The RunningValue property indicates the current setting of the option on a running SQL Server installation. Prior to changing the configuration option setting, the CurrentValue and the RunningValue properties return identical values.
Set the CurrentValue property to change the setting of the given SQL Server configuration option. Undo your changes by resetting the CurrentValue property to the value of the RunningValue property. After a change is applied, the values of these two properties are again equal.
To set a configuration option
CurrentValue Property | MaximumValue Property |
Description Property | MinimumValue Property |
DynamicReconfigure Property | Name Property |
ID Property | RunningValue Property |