Printed 2016/10/27 05:06AM

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.
Copyright © 2002-2016 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.