通过

  • 项目

ConfigValues Collection

后续版本的 Microsoft SQL Server 将删除该功能。 请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。

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

显示当前对象的 SQL-DMO 对象模型

Methods

Refresh Method

 

注释

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")

请参阅

参考

sp_configure (Transact-SQL)