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.