SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Katie and Emil

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.

reconfigure vs reconfigure with override

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.


Leave a comment on the original post [www.katieandemil.com, opens in a new window]

Loading comments...