SQL Server Performance Forum – Threads Archive
sp_configure default optionsHi friends,
Is there anyway to bring back all the configuaration option values to default values?
Thanks in advance.
I think that the only ways are:
– reinstall SQL Server
– manually set each option to its default value. Most of these are in Books Online under sp_configure, setting configuration options Cheers
I think the second option referred Twan is the other way round, than reinstalling SQL instance again. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.