Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spinman
Starting Member
9 Posts |
 Posted - 2007-03-06 : 16:35:15
|
| The strangest thing started happening. It had been a while since I had been in this SQL server, I opened Enterprise Manager, chose the database I needed, right clicked, chose properties and Enterprise Manager closed. I tried all the other databases with same results.SQL 2000 on an W2003 ServerI am not sure where to even start.Spinman |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-06 : 16:44:17
|
| Have you installed service pack 4 on your client machine? Service packs should be installed on the clients as well as servers as service packs often contains fixes for the client tools (which Enterprise Manager is).Tara Kizer |
 |
|
|
spinman
Starting Member
9 Posts |
Posted - 2007-03-06 : 16:54:03
|
| SQL 2000 SP3, Ent Man 8.0It was all working fine the last time I checked them. As far I know nothing has been added or changed (service pack wise).Spinman |
|
|
|
spinman
Starting Member
9 Posts |
Posted - 2007-03-06 : 17:15:03
|
| I found a simular post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57576It addresses the same exact Error message without a solution.Error: 15457, Serverity: 0, State: 1Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.....So the question then becomes "How to run the RECONFIGURE" statement?Is it just running "reconfigure" in QA? or is there more to the command?Spinman |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-06 : 17:28:50
|
| Error 15457 just means that someone changed a configuration option using sp_configure. That error isn't what is causing your Enterprise Manager problems. 14547 isn't really an error.But yes you just run RECONFIGURE in Query Analyzer for the changes to take effect (only works for certain options though). You could also restart the SQL Server service or reboot the box.Tara Kizer |
|
|
|
|
|
|
Enterprise Manager closes when choosing properties