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