Jaa

ConfigValues Collection

  • Artikkeli

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

SQL-DMO object model that shows the current object

Methods

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.

To reference a specific SQL Server engine parameter

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

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

See Also

Other Resources

sp_configure (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance