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;