Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Reconfigure Question

    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

    THis is the error that I am receiving, suggesting that I have made a change to the configuration, which I haven't, anway I have responded with this code:

    USE master
    EXEC sp_configure 'show advanced option', '1'

    EXEC sp_configure

    However I don't know if anything have change with the configuration. I am new to the DBA world. HELLLP!!!

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Relax, everything is cool. Don't "answer" to the errorlog, or SQL would start thinking you're Kasparov and the box is a Cray, which may not be good for it

    But seriously, anything under severity level 11 is informational, it's just being logged to the error log, so you can just ignore it.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Aug 2002
    actually, according to my experience, this is caused by just reviewing server options in Enterprise Manager, some of them are advanced options and switch of 'show advanced options' parameter must be done. From this comes the info in errorlog.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts