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.
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.