Post reply

I want to drill it::Just for knowledge

  • September 13, 2011 at 1:24 am

    #244866

    http://www.aspfaq.com/sql2005/show.asp?id=29

    EXEC sp_configure 'xp_cmdshell', 1

    You will get this error:

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

    The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option.

    Thanks

  • September 13, 2011 at 1:31 am

    #1380438

    If your question is why the statement like that doesn't work just look at the last part of the errormessage "or it may be an advanced option".

    Under the default configuration settings you cannot change advanced settings directly, you first have to enable the "Show advanced settings" option.

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

  • September 13, 2011 at 1:38 am

    #1380441

    exec sp_configure 'show advanced options',1;

    go

    reconfigure;

    go

    EXEC sp_configure 'xp_cmdshell', 1;

    go

    reconfigure;

    go

  • September 13, 2011 at 2:38 am

    #1380458

    Thanx Markus

    Thanks

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

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