ReconfigureCurrentValues Method

В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.

The ReconfigureCurrentValues method applies changes to configuration options made by changing the properties of the ConfigValue objects contained in the Configuration object's ConfigValues collection.

Синтаксис

object
.ReconfigureCurrentValues(
)

Parts

• object
  Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

HRESULT ReconfigureCurrentValues();

Замечания

When using the ReconfigureCurrentValues method, Microsoft SQL Server tests configuration option settings as they are applied. Some configuration options have only a single setting that passes a validity check, and the ReconfigureCurrentValues method fails when attempting to apply a change to the option. Use the ReconfigureWithOverride method to disable validity checking for options.

Важно!
Some configuration option changes applied by setting ConfigValue object properties and using the ReconfigureCurrentValues method take effect immediately. Other changes require that the SQL Server service be stopped and restarted. When a change requires service restart, you must first apply the change by using ReconfigureCurrentValues, then stop and start the SQL Server service.

Setting configuration options by using the ConfigValue object and ReconfigureCurrentValues method requires appropriate permission. The SQL Server login used for SQLServer object connection must be a member of the fixed server role sysadmin.

Applies To:

См. также

Справочник

ConfigValue Object

Справка и поддержка

Получение помощи по SQL Server 2005