You set or change configuration parameters in one of the following ways:
By executing the system procedure 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 go into effect as soon as you execute sp_configure. Static parameters require Adaptive Server to reallocate memory, so they take effect only after Adaptive Server has been restarted. The description of each parameter 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, not when you restart Adaptive Server. The current configuration file and sysconfigures reflect configured values, not run values. The system table syscurconfigs reflects current run values of configuration parameters.
