default config values

  • Hi Guys,

    Where will get all default configuration values of the sqlserver 2000.

    Thanks in advance


    Kindest Regards,

    karthik

  • you can make use of server property..... function or

    execute

    exec master..xp_msver

  • you just execute master..sp_configure or

    you can make use of server property..... function or

    execute

    exec master..xp_msver

  • I am looking for default server settings like connections, no.of errorlogs and job history log...

    Will we have any proc/function to find out those....

    Thanks, Karthik


    Kindest Regards,

    karthik

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

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