Change the SQL Server Configuration Option
You can use sp_configure with RECONFIGURE to display or change server-level settings. However, some configuration options require a server stop and restart to update the currently running value. RECONFIGURE does