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.
~vvkp

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
Twan

I think the second option referred Twan is the other way round, than reinstalling SQL instance again. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>