Updates the currently configured value (the config_value column in the sp_configure result set) of a configuration option changed with the sp_configure system stored procedure. Because some configuration options require a server stop and restart to update the currently running value, RECONFIGURE does not always update the currently running value (the run_value column in the sp_configure result set) for a changed configuration value.
Applies to: SQL Server (SQL Server 2008 through current version).
sp_configure does not accept new configuration option values out of the documented valid ranges for each configuration option.
RECONFIGURE is not allowed in an explicit or implicit transaction. When you reconfigure several options at the same time, if any of the reconfigure operations fail, none of the reconfigure operations will take effect.
The following example sets the upper limit for the recovery interval configuration option to 75 minutes and uses RECONFIGURE WITH OVERRIDE to install it. Recovery intervals greater than 60 minutes are not recommended and disallowed by default. However, because the WITH OVERRIDE option is specified, SQL Server does not check whether the value specified (90) is a valid value for the recovery interval configuration option.
EXEC sp_configure 'recovery interval', 75' RECONFIGURE WITH OVERRIDE; GO