sp_configure is an useful SP, and we can display or change global configuration settings for the current server with it.
By default, you can't display advanced options when executing sp_configure. To show them, you must set show advanced option to 1 firsrt by executing below script:
USE master
GO
EXEC sp_configure 'show advanced option', '1' --the default is 0
RECONFIGURE --reasonable
Executing sp_configure with no parameters displays all configuration options:
EXEC sp_configure
Another instance:
USE master
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', '1'
RECONFIGURE WITH OVERRIDE --forced
