The Effect of the Display Level on sp_configure Output

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 example, if your display level is set to intermediate, and you want to see the parameters in the languages group, enter:
sp_configure "Languages"

The output looks 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
. . . 

This represents only a subset of the parameters in the languages group; some language parameters appear only when your display level is comprehensive.