共用方式為

  • 發行項

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)