Re: logs - configuration option changed
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/08/04
- Next message: chrisben: "Re: How can I select Max and Min value from a row?"
- Previous message: Aaron [SQL Server MVP]: "Re: unable to edit Index name?"
- In reply to: Dan D.: "Re: logs - configuration option changed"
- Next in thread: Dan D.: "Re: logs - configuration option changed"
- Reply: Dan D.: "Re: logs - configuration option changed"
- Messages sorted by: [ date ] [ thread ]
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. > > > > > >
- Next message: chrisben: "Re: How can I select Max and Min value from a row?"
- Previous message: Aaron [SQL Server MVP]: "Re: unable to edit Index name?"
- In reply to: Dan D.: "Re: logs - configuration option changed"
- Next in thread: Dan D.: "Re: logs - configuration option changed"
- Reply: Dan D.: "Re: logs - configuration option changed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|