SHOW ADVANCED OPTION

  • Configuration option 'show advanced options' changed from 0 to 1. Run

    the RECONFIGURE statement to install.

    Msg 5832, Level 16, State 1, Line 1

    The affinity mask specified does not match the CPU mask on this

    system.

    Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51

    The configuration option 'affinity mask' does not exist, or it may be

    an advanced option.

    Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51

    The configuration option 'affinity I/O mask' does not exist, or it may

    be an advanced option.

    Msg 5832, Level 16, State 1, Line 1

    The affinity mask specified does not match the CPU mask on this

    system.

    Configuration option 'show advanced options' changed from 1 to 0. Run

    the RECONFIGURE statement to install.

    Msg 5832, Level 16, State 1, Line 1

    The affinity mask specified does not match the CPU mask on this

    system.

  • Perhaps you could also show the code you're running and explain what you're trying to do. Just showing error messages doesn't really help. Would you ask someone a question like this in your office?

  • Let's say the "show advanced options" option is disabled. Does this mean that everything listed as an advanced option is disabled as well?

    Thanks!

  • cstg85 (1/30/2013)


    Let's say the "show advanced options" option is disabled. Does this mean that everything listed as an advanced option is disabled as well?

    No.

    In future please post new questions in a new thread. Thanks

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

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