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.