Syntax changes to sp_helpconfig:
A new option, cluster options, displays all strictly cluster-wide configuration options. The syntax is:
sp_helpconfig “cluster options”
Usage changes:
If system_view is set to cluster, sp_helpconfig displays configuration information for all instances in the cluster.
If system_view is set to instance, sp_helpconfig displays configuration information for the current instance.