To set the show advanced options optionUse the show advanced options option to display the sp_configure system stored procedure advanced options. When you set show advanced options to 1, you can list the advanced options by using sp_configure. The default is 0.
The setting takes effect immediately (without a server stop and restart).
To set the show advanced options option
| RECONFIGURE | sp_configure |
| Setting Configuration Options |