为什么“不支持对系统目录进行即席更新”

在sql server2005中，执行如下命令的问题

exec sp_configure 'show advanced options', 1
RECONFIGURE;
exec sp_configure 'Ole Automation Procedures', 1
RECONFIGURE;

在执行中显示错误

不支持对系统目录进行即席更新。

修改为

exec sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE;
exec sp_configure 'Ole Automation Procedures', 1
RECONFIGURE WITH OVERRIDE;

可以正常运行，不知道是什么原因导致的。

在网上找到一段信息

RECONFIGURE

    Specifies that if the configuration setting does not require a server stop and restart, the currently running value should be updated. RECONFIGURE also checks the new configuration values for either values that are not valid (for example, a sort order value that does not exist in syscharsets) or nonrecommended values. With those configuration options not requiring a server stop and restart, the currently running value and the currently configured values for the configuration option should be the same value after RECONFIGURE is specified.
   
   
WITH OVERRIDE
       
    Disables the configuration value checking (for values that are not valid or for nonrecommended values) for the recoveryinterval advanced configuration options.

    Any configuration option can be reconfigured by using the WITH OVERRIDE option. In addition, RECONFIGURE WITH OVERRIDE forces the reconfiguration with the specified value. For example, the minservermemory configuration option could be configured with a value greater than the value specified in the maxservermemory configuration option. However, this is considered a fatal error. Therefore, specifying RECONFIGURE WITH OVERRIDE would not disable configuration value checking.

转载于:https://www.cnblogs.com/hutou/archive/2011/06/24/2089018.html