SQL Server Performance Forum – Threads Archive
configuration option error
we have an app that suddenly generates the following errors in the SQL error log when we attempt to start the app: Configuration option ‘show advanced options’ changed from 1 to 1. Run the RECONFIGURE statement to install.. Then Error: 15457, Severity: 0, State: 1 Any thoughts?Thanks.
run this command in query analyzer
sp_configure ‘show advanced options’,’0′
reconfigure with override then start the application.. tell me if it works or not…. krishna chaitanya sanka
project engineer-SQLDBA ‘TO IMPROVE IS TO CHANGE….TO BE PERFECT IS TO CHANGE OFTEN!!!!
This is an informational messages whenever any configuration statements were executed, you can ignore them. 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.
]]>