RECONFIGURE

SQL Server

Example

USE AdventureWorks2012 ;
GO
EXEC sp_configure 'show advanced options', 1 ;
RECONFIGURE ;
GO

Output

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

Explanation

The above example changes the configuration setting ‘show advanced options’ to 1. RECONFIGURE executes the current configuration changes. The USE statement specifies to change the database context to AdventureWorks2012. The GO command is used to separate batches of SQL statements.