Syntax changes for the Cluster Edition:
You can now specify an instance name to set an instance-specific option. The syntax is:
sp_configure [configuration_option [, config_value [,...]]] [, instance_name]
A new option, drop instance, allows you to drop an instance-specific configuration setting. The syntax is:
sp_configure configuration_option, 0, “drop instance”, instance_name
Usage changes for display:
If no configuration option or instance name is specified, the information displayed depends on the system_view setting.
If no configuration option is specified, and the instance name is specified, Adaptive Server displays all instance-specific configuration settings for the specified instance.
If the configuration option is specified, but the configuration value and instance name are not specified, Adaptive Server displays the current settings for the specified option for all instances under the “cluster” view. If the instance name is specified, Adaptive Server displays configuration information for the specified instance.
Usage changes when setting options:
If the configuration option and value are specified, but no instance is specified, Adaptive Server configures the cluster-wide setting for the option. If, however, the instance name is specified, Adaptive Server sets the configuration value for the instance only. The syntax is:
sp_configure configuration_name, config_value, NULL, instance_name
You cannot set configuration options from inside a local temporary database.
If an instance already has instance-specific setting for a configuration parameter set, you can reconfigure this parameter for a cluster-wide setting.
A user can reconfigure only those instances to which they are connected.
