RECONFIGURE

RECONFIGURE is a Transact-SQL command in SQL Server. It's used to update the currently running configuration value of a specific feature with the value specified in the 'sp_configure' system stored procedure. This command essentially implements any configuration changes made with 'sp_configure'.

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.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.