sp_configure default options | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sp_configure default options

Hi 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.