Re: logs - configuration option changed

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