When using
sp_configure with the
Cluster Edition:
-
Configure an instance-specific
value that applies only to the instance to which you are currently connected.
-
Configuration options that are “strictly cluster-wide”—that is, the small group of configuration options that are the same on all instances—cannot be made instance-specific.
-
Reconfiguring a cluster-wide value does not overwrite
an instance-specific configuration.