Post reply

Serverlog: run reconfigure statement

  • January 29, 2007 at 5:17 am

    #175705

    while reading my sqlserverlog i found the following entry:

    Configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE statement to install.

    when nothing is changed (user options from 0 to 0) - why should i run the reconfigure statement?

    does anyone knows something about this?

    thx in advance

    mario - germany 

  • January 29, 2007 at 8:05 am

    #686169

    what was the statement that you used before you got this message.

    i hope you should have used

    sp_configure 'user options',0

    sql server treats this to be a configuration change and asks you to run the reconfigure statement though nothing has really changed in the background. This is by default of sql server processing mechanism.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • January 29, 2007 at 11:31 pm

    #686370

    no, i didn´t use the sp_configure'user options',0 statement!

    it´s a backup task which is producing this log.

    First task is a dbcc check db to check the consistence of the db followed by a full backup.

    here`s the log-sequence:

    01/25/2007 10:53:44,spid81,Unbekannt,Configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE statement to install.

    01/25/2007 10:50:27,,Unbekannt,Database backed up. Database: tera_prg<c/> creation date(time): 2007/01/16(16:04:43)<c/> pages dumped: 39846<c/> first LSN: 11805:1140:37<c/> last LSN: 11805:1156:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'tera_prg'}). This is an informational message only. No user action is required.

    01/25/2007 10:50:15,spid79,Unbekannt,DBCC CHECKDB (tera_prg) WITH no_infomsgs executed by sa found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 11 seconds.

     

    I think it`s nothing serious, because the other sqlverver did the same.

    But I would like to know what the causes are.

    Mario

  • January 30, 2007 at 3:46 am

    #686390

    Mario

    no need to worry about this. Some applications need specific cnfiguration settings. That's why they issue a sp_configure statement each time they run, just to make sure the setting is right.

    SQL Server always follows a sp_configure with a message to run RECONFIGURE even if you already included this command in your code. Probably if you run a trace qou will see that your backup app sends a RECONFIGURE command.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • January 30, 2007 at 3:53 am

    #686391

    @all

    thanks for your replies

    Mario

     

     

  • November 27, 2013 at 10:35 pm

    #1669613

    I was confused when I saw this message.

    Thanks for the information provided Markus

    Abhilash

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply