RECONFIGURE Statement

Installs a changed configuration option used only with the sp_configure system stored procedure.

Syntax

RECONFIGURE [WITH OVERRIDE]

where

WITH OVERRIDE

Instructs SQL Server to accept the values for system variables supplied by the user (with the sp_configure stored procedure). If the user supplies values that SQL Server cannot accept, an error message telling the user to re-execute sp_configure is displayed.

The WITH OVERRIDE clause must always be used when the system administrator sets the allow updates option to 1.

Note Never use the RECONFIGURE statement to change the default sort order of SQL Server.

See Also