This topic has not yet been rated - Rate this topic

ConfigProperty.ConfigValue Property

SQL Server 2012

SQL Server 2005

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

C++

JScript

public int ConfigValue { get; set; }

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

Reference

ConfigProperty Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Server Configuration Options (SQL Server)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD