T-SQL sp_configure

On Transact SQL language the sp_configure is part of Database Engine Stored Procedures and displays or changes global configuration settings for the current server.

Sp_configure syntax:

sp_configure [ [ @configname = 'option_name' ] , [ @configvalue = ] 'value' ];


Sp_configure example:

USE model;
GO
EXEC sp_configure 'show advanced option', '1';

Messages
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

RECONFIGURE;
EXEC sp_configure;