次の方法で共有

  • [アーティクル]

Configuration Object

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。 新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。

The Configuration object represents Microsoft SQL Server engine-configurable parameters and values.

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

説明

With the Configuration object, you can:

  • Get current SQL Server configuration options.

  • Reset one or more SQL Server configuration options.

The ShowAdvancedOptions property of the Configuration object controls the membership of the ConfigValues collection. Each ConfigValue object in the collection represents a specific SQL Server configuration option. For more information about advanced options, see サーバー構成オプションの設定.

Some SQL Server configuration options do not take effect until the SQL Server service has been stopped and restarted. You can force the server to immediately accept changes in some options using the ReconfigureWithOverride method.

To set a configuration option

  1. Get the Configuration object from a connected SQLServer object.

  2. Get the ConfigValue object of the required configuration option from the ConfigValues collection of the Configuration object.

  3. Set the CurrentValue property of the ConfigValue object to reflect the required change.

  4. Use either the ReconfigureCurrentValues or the ReconfigureWithOverride method of the Configuration object to apply the change to an instance of SQL Server.

  5. If necessary, use the Shutdown and Start methods of the SQLServer object to restart the server with the changed configuration options.