We are Katie & Emil and together we have decided to learn more & more on how to build data warehouses using Microsoft products. The best option to learn is to teach so we write tutorials and share it with others.
You can change server properties of SQL Server using sp_confgure and to "save" it you need to use reconfigure. In this blog post I describe the difference between reconfigure and reconfigure with override. I also provide an example when reconfigure will fail and give you an error message and another example with override that works.