Set or change configuration parameters in one of the following ways:
By executing sp_configure with the appropriate parameters and values,
By editing your configuration file and then invoking sp_configure with the configuration file option, or
By specifying the name of a configuration file at start-up.
Configuration parameters are either dynamic or static. Dynamic parameters take effect as soon as you execute sp_configure. Static parameters require memory to be reallocated, so they take effect only after you have restarted Adaptive Server. The description of each parameter in this chapter indicates whether it is static or dynamic.
Adaptive Server writes the new value to the system table sysconfigures and to the configuration file when you change the value. The current configuration file and sysconfigures reflect configured values, not run values. The system table syscurconfigs reflects current run values of configuration parameters.
