Hi friends! This article was built based on "SQL Server" forum discussion thread (check it at: http://www.myitforum.com/forums/m_111468/mpage_1/key_/tm.htm#138786).
Q::
I get this in my SQL logs every time my backup runs. I ran the "Reconfigure with override" on the master table and it didn't clear the issue up. Does anyone else have any ideas on how to stop it or what it is trying to do?
2005-06-23 15:39:39.44 spid52 Configuration option ' show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2005-06-23 15:39:39.44 spid52 Error: 15457, Severity: 0, State: 1
2005-06-23 15:40:09.13 spid52 Configuration option ' show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2005-06-23 15:40:09.13 spid52 Error: 15457, Severity: 0, State: 1
2005-06-23 15:40:17.44 spid52 Configuration option ' show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2005-06-23 15:40:17.44 spid52 Error: 15457, Severity: 0, State: 1
2005-06-23 15:43:32.23 spid52 Configuration option ' show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2005-06-23 15:43:32.23 spid52 Error: 15457, Severity: 0, State: 1
2005-06-23 15:57:55.10 spid71 Using ' smsxp.dll' version ' 0002.50.3174' to execute extended stored procedure '
2005-06-23 20:00:42.90 spid54 Using ' xplog70.dll' version ' 2000.80.760' to execute extended stored procedure
2005-06-24 00:02:42.64 spid51 Configuration option ' show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2005-06-24 00:02:42.64 spid51 Error: 15457, Severity: 0, State: 1
Answer from Brian Tucker ( http://www.myitforum.com/forums/showProfile.asp?memid=5833) :
Brian,
Read my reply on this post in the SMS forum.
http://www.lazydba.com/sql/1__4146.html
A_2:
This is not a problem / error at all! Do not pay attention on it! Or ... do not use your Enterprise Manager 兒
A_3:
Hi Brian,
Yes this is an informational message in fact, not really an error message. If you change your server properties (<-- this is not your situation!!!) or view them in Enterprise Manager (<-- THIS IS YOUR SITUATION!!!), you will see this message. So, don't worry about this message!
