Share via


ReconfigureWithOverride Method

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 ReconfigureWithOverride method applies changes to configuration options made by changing the properties of the ConfigValue objects contained in the Configuration object's u collection.

Syntax

object
.ReconfigureWithOverride(
)

Parts

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

Prototype (C/C++)

HRESULT ReconfigureWithOverride();

Remarks

Use the ReconfigureWithOverride method to disable option value validity checking when using the ConfigValue object to set Microsoft SQL Server configuration options.

Important

Some configuration option changes applied by setting ConfigValue object properties and using the ReconfigureWithOverride 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 ReconfigureWithOverride, then stop and start the SQL Server service.

Setting configuration options by using the ConfigValue object and ReconfigureWithOverride 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:

Configuration Object

See Also

Reference

ConfigValue Object

Help and Information

Getting SQL Server 2005 Assistance