This table contains an entry for each of the configuration options, as does sysconfigures, but syscurconfigs contains the current values. In addition, it contains four entries that describe the configuration structure. The syscurconfigs table is built dynamically when queried by a user. For details, see the sysconfigures topic.
sp_configure | sp_helpsort |