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

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.

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.


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

Loading comments...