ConfigProperty ConfigProperty ConfigProperty Class

Definition

The ConfigProperty object contains information pertaining to a Microsoft SQL Server configuration option, such as maximum, minimum, current, and new values.

public ref class ConfigProperty sealed
public sealed class ConfigProperty
Public NotInheritable Class ConfigProperty
Inheritance
ConfigPropertyConfigPropertyConfigProperty

Examples

Configuring SQL Server in SMO

Remarks

The ConfigProperty object is used to modify or retrieve information about configuration options that are children of the Configuration object.

To get ConfigProperty object properties, users can be a member of the public fixed server role.

To set ConfigProperty object properties, users must have ALTER SETTINGS permission on the parent server, or be a member of the sysadmin and serveradmin fixed server role.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Properties

ConfigValue ConfigValue ConfigValue

Gets or sets the new value of the configuration option.

Description Description Description

Gets a textual description of the configuration property.

DisplayName DisplayName DisplayName

Gets the name of the configuration option being modified.

IsAdvanced IsAdvanced IsAdvanced

Gets the Boolean property value that specifies whether the configuration option is an advanced option.

IsDynamic IsDynamic IsDynamic

Gets the Boolean property value that specifies whether the configuration option is immediately updated or waits until the instance of Microsoft SQL Server is restarted.

Maximum Maximum Maximum

Gets the maximum value to which the configuration option can be set.

Minimum Minimum Minimum

Gets the maximum value to which the configuration option can be set.

Number Number Number

Gets the index position of the configuration option.

RunValue RunValue RunValue

Gets the current running value of the configuration option.

Applies to