http://www.sqlservercentral.com/blogs/katie-and-emil/2012/07/28/reconfigure-vs-reconfigure-with-override/

Printed 2014/10/02 06:50AM

reconfigure vs reconfigure with override

2012/07/28

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