ConfigValues Collection

SQL-DMO

SQL-DMO

ConfigValues Collection

The ConfigValues collection contains ConfigValue objects that expose settings for configurable Microsoft® SQL Server™ engine parameters.

Methods
ItemByID Method Refresh Method
Remarks

The ConfigValues collection is fixed in membership and does not expose Add and Remove methods. The ShowAdvancedOptions property of the Configuration object controls the membership of the ConfigValues collection.

Use the ConfigValues collection to reference a specific SQL Server engine parameter, for example:

Set oConfigValue = oSQLServer.Configuration.ConfigValues("remote query timeout")

See Also

Setting Configuration Options