Search notes:
SQL Server: reconfigure
The
reconfigure
or
reconfigure with override
statements are required after changing a
server property
with
sp_configure
.
reconfigure
executes within a
transaction
: either all or none of the reconfiguration opteraions take effect.
See also
T-SQL statements
Index