Ms Sql Error 15457 Severity 0 State 1
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » Error: 15457, Severity: 0, State: 1 Error: 15457, Severity: 0, State: 1 Rate Topic Display Mode Topic Options Author Message JpotucekJpotucek Posted Wednesday, December 28, 2005 12:46 PM Right there with Babe Group: General Forum Members Last Login: Thursday, October 13, 2016 8:38 AM Points: 786, Visits: 1,647 I am getting these errors in my event log periodically:Error: 15457, Severity: 0, State: 1and thenConfiguration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..I'm not sure what to make of these errors or how to begin researching.. can anyone help?? Post #247019 noeldnoeld Posted Wednesday, December 28, 2005 12:52 PM SSCertifiable Group: General Forum Members Last Login: Yesterday @ 9:27 AM Points: 6,262, Visits: 2,048 I've seen this type of messages when monitoring tools change the 'show advanced options' and forget to execute RECONFIGURE after it.because this is a server wide setting all that is needed is for you to run RECONFIGURE maually. This is not a big problem but you will need to look for the offending party if you want to get rid of this message on the sql logsCheers, * Noel Post #247022 Joshua Jones-214598Joshua Jones-214598 Posted Wednesday, December 28, 2005 12:58 PM SSC Veteran Group: General Forum Members Last Login: Tuesday, December 5, 2006 7:27 AM Points: 235, Visits: 1 The other thing that causes this is simply opening up the server properties dialog in Enterprise Manager and clicking OK to exit instead of Cancel (i.e. a DBA goes to look at the Startup Parameters, then after verifying clicks the OK button to close the dialog box). Cheers,Joshua Jones Post #247023 JpotucekJpotucek Posted Wednesday, December 28, 2005 1:15 PM Right there with Babe Group: General Forum Members Last Login: Thursday, October 13, 2016 8:38 AM Points: 786, Visits: 1,647 Thank you. I did go into the Server Properties a couple of time through EM and then X'd out. maybe that caused the errors... I seem to get them periodically and didn't know if it was a problem. I have been having a problem yesterday and today with a moniter
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums SQL Server Administration (2000) Error: 15457, Severity: 0, State: 1 Reply to Topic Printer Friendly Author Topic asarak Starting Member Greece 36 Posts Posted-12/07/2005: 06:52:38 Hi Guys, i ve got a problem.Suddenly while i was trying to get http://www.sqlservercentral.com/Forums/Topic247019-5-1.aspx into the Enterprise Manager -- In the Current Activity, to see the locks i receive the following message:Error 1222, Lock request time out period exceeded.I am looking also to the log and saw the error:Error: 15457, Severity: 0, State: 1I am trying from the server console itself but there is the same effect... Some times work but others (mostly) failed...I also check the query timeout option in the server and i found that is about http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58726 600 ms (not 0 which is unlimited) but this was changed many months ago.Thanks a lotAny suggestions???RegardsAsarak SQLServerDBA_Dan Aged Yak Warrior USA 752 Posts Posted-12/07/2005: 08:39:15 quote:Originally posted by asarakI am looking also to the log and saw the error:Error: 15457, Severity: 0, State: 1This error appears when you open the server properties in Enterprise Manager. It's more informational than an actual error. I wouldn't worry too much about it.quote:Originally posted by asarakSuddenly while i was trying to get into the Enterprise Manager -- In the Current Activity, to see the locks i receive the following message:Error 1222, Lock request time out period exceeded.I also check the query timeout option in the server and i found that is about 600 ms (not 0 which is unlimited) but this was changed many months ago.Do you mean the "query timeout" option in Query Analyzer? Mine's set to "0" and "lock time-out" is set to "-1".Do all queries time out? Are you the only one that is having time outs?Daniel, MCP, A+SQL Server DBAwww.dallasteam.com bakerjon Posting Yak Master USA 145 Posts Posted-12/07/2005: 08:58:18 Short answer--don't use Current Activity monitor in SEM. It is known to cause these issues. Instead use the sp_who and sp_who2 system stored procs, or as I'm becoming more accustomed to, just select from master.dbo.sysprocesses di
3:14:00 PM) Source spid78 Message Error: 15457, ms sql Severity: 0, State: 1 Date 7/25/2008 12:27:08 AM Log SQL Server (Archive #2 - 8/12/2008 3:14:00 PM) Source spid78 Message Configuration option 'show advanced options' changed ms sql error from 1 to 1. Run the RECONFIGURE statement to install.. Cause. This is an informational message. It is not an error. When the sp_configure system stored procedure is used to set a configuration option, you need to run either RECONFIGURE or RECONFIGURE WITH OVERRIDE Solution. Use Enterprise Manager or SQL Server Management Studio to run the RECONFIGURE command. .Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.