مشاركة عبر


ConfigProperty.ConfigValue Property

Gets or sets the new value of the configuration option.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Property ConfigValue As Integer 
    Get 
    Set
'Usage
Dim instance As ConfigProperty 
Dim value As Integer 

value = instance.ConfigValue

instance.ConfigValue = value
public int ConfigValue { get; set; }
public:
property int ConfigValue {
    int get ();
    void set (int value);
}
member ConfigValue : int with get, set
function get ConfigValue () : int 
function set ConfigValue (value : int)

Property Value

Type: System.Int32
An Int32 value that specifies the new value of the configuration option.

Remarks

Some configuration options are dynamic and the running value is immediately updated when the ConfigValue property is set. The running value can be obtained by retrieving the RunValue property. Other configuration options are not dynamic and the configuration option is updated when the instance of Microsoft SQL Server is restarted. After setting the ConfigValue property the RunValue property is not updated until after the server is restarted.

Examples

Configuring SQL Server in SMO

See Also

Reference

ConfigProperty Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Server Configuration Options (SQL Server)