If your display level is set to either “basic” or “intermediate,” sp_configure returns only a subset of the parameters that are returned when your display level is set to “comprehensive.” For instance, if your display level is set to “intermediate,” and you want to see the parameters in the Languages group, type:
sp_configure "Languages"
The output would look like this:
sp_configure Group: Languages Parameter Name Default Memory Used Config Value Run Value Unit Type --------------- ------- ----------- ------------ --------- ---- ---- default character set 1 0 1 1 id static default language id 0 0 0 0 id dyna . . .
However, this is only a subset of the parameters in the Languages group, because some parameters in that group are displayed only at the “comprehensive” level.
