Re: logs - configuration option changed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 13:20:19 -0400

Do you have a maintenance plan set up and if so does it have the option to
fix minor errors? This may cause an entry like this but I am not 100 %
sure. Are there any scheduled jobs that collect information from the server
with say sp_dboption? 

-- 
Andrew J. Kelly  SQL MVP
"Dan D." <DanD@discussions.microsoft.com> wrote in message
news:95E34CD1-BDFA-423B-B05B-C319F7E8E3E3@microsoft.com...
> No one claims to have been on the system at that time (1 AM local time).
Could some system process make the changes?
>
> Thanks,
> -- 
> Dan D.
>
>
> "Andrew J. Kelly" wrote:
>
> > That is usually associated with someone using EM to view certain
options.
> > It is nothing to be concerned with.
> >
> > -- 
> > Andrew J. Kelly  SQL MVP
> >
> >
> > "Dan D." <DanD@discussions.microsoft.com> wrote in message
> > news:FAD761D0-4D1B-4EB4-BF9E-18155CC0ED9C@microsoft.com...
> > > Using SS2000. I often see a line in the logs that says "configuration
> > opton 'allow updates' changed from 0 to 1. Run the RECONFIGURE s Error
> > 15457, serverity 0, State 1"
> > >
> > > Another entry will change the option from 1 to 0. What's going on? Is
a
> > dts package doing this as part of a normal run?
> > >
> > > Thanks,
> > > -- 
> > > Dan D.
> >
> >
> >

Relevant Pages

  • Re: logs - configuration option changed
    ... No one claims to have been on the system at that time (1 AM local time). ... Could some system process make the changes? ... > Andrew J. Kelly SQL MVP ... > "Dan D." ...
    (microsoft.public.sqlserver.server)
  • Re: logs - configuration option changed
    ... Andrew J. Kelly SQL MVP ... "Dan D." ... dts package doing this as part of a normal run? ...
    (microsoft.public.sqlserver.server)
  • Negative results
    ... Andrew J. Kelly wrote: ... Sorry thanks for pointing that out Kevin. ... Andrew J. Kelly SQL MVP ... Your best option to begin with is to look at the virtual file stats to seehow ...
    (microsoft.public.sqlserver.server)
  • Re: Extremely high % Disk Time .. How is this possible??
    ... Andrew J. Kelly SQL MVP ... > Slicing them into logical drives may look better but it does not increase ... I prefer to look at disk queue ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: disk I/O tool
    ... Andrew J. Kelly SQL MVP ... "Jay" wrote in message ... I guess he really doesn't understand SAN's very well either because SAN's are notoriously slow for writing small but frequent I/O's and direct attached drives will often outperform them hands down. ...
    (microsoft.public.sqlserver.server)