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 |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2005-04-07 : 06:31:20
|
| HI,my development SQL Server 2000 came up with an error this morning saying"Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..""Error: 15457, Severity: 0, State: 1"Now how do i identify which configuration option has changed and how do i rectify it.Thanks,V David |
|
|
rfrancisco
Yak Posting Veteran
95 Posts |
Posted - 2005-04-07 : 09:54:59
|
| Look into sp_configure. It will show you the currently running values and you can compare it against the configured/changed values. You will also use the same stored procedure to set/reset the values. |
 |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-07 : 15:08:17
|
| Nothing may changed. I believe that error is generated when you enter the server properties.EM will also show you running vs configured. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-08 : 01:34:59
|
check the current first,then run the reconfigure statement (the changes will apply then)then compare... --------------------keeping it simple... |
|
|
|
|
|
|
'show advanced options'