Post reply

SP_configure confiuration

  • February 5, 2008 at 2:52 am

    #186196

    Hi Guys,

    Can anyone tell me,How to configure each and every parameters in sp_configure script?

    Thanx in advance,:P

    Ram

  • February 5, 2008 at 3:07 am

    #775025

    Hey,

    Here's syntax example, but you may want to have a look a BOL for more information:

    sp_configure [ [ @configname = ] 'option_name'

    [ , [ @configvalue = ] 'value' ] ]

    Thanks,

    Phillip Cox

  • February 5, 2008 at 4:17 am

    #775037

    As per your environment you need to set the parameters of sp_configure. In case if you are not sure use the default settings. Refer BOL and microsoft sites for more details.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • February 6, 2008 at 2:45 pm

    #775794

    After setting a value you will need to run the RECONFIGURE statement (or the RECONFIGURE WITH OVERRIDE statement if the value is not "reasonable"; see BOL for details) for the settign to take effect.

    Also, you can not see all the configuration settings until you set show advanced options to 1:

    EXEC sp_configure 'show advanced option', '1';

    RECONFIGURE;

    EXEC sp_configure;

    It's detailed well in BOL.

    Regards,

    Matt Karp

    Best Regards,

    Matt Karp

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

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