Post reply

Enable xp_cmdshell in sql 2000

  • July 24, 2008 at 10:46 pm

    #71763

    I am trying to create an sp on sql 2000 which uses xp_cmd shell. I get the following error

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

    I have tried to enable it using the sp_configure

    EXEC master.dbo.sp_configure 'allow updates', 1

    RECONFIGURE with override

    EXEC master.dbo.sp_configure 'show advanced options', 1

    RECONFIGURE with override

    EXEC master.dbo.sp_configure 'xp_cmdshell', 1

    RECONFIGURE with override

    Please let me know your suggestions

  • July 24, 2008 at 10:48 pm

    #848202

    What is your code?

    xp_cmdshell is in master, so you might need to call it as

    exec master.dbo.xp_cmdshell

  • July 24, 2008 at 11:23 pm

    #848210

    my 2 cents...

    i did not see xp_cmdshell configuration option in sp_configure.

    "Keep Trying"

  • July 24, 2008 at 11:27 pm

    #848211

    EXEC master.dbo.XP_CMDSHELL @query

    This is the part of the sp, where @query is a statement. This should be fine because it has run succesfully on the remaining sql 2000 servers..

  • July 24, 2008 at 11:32 pm

    #848213

    Its only on 3 servers that Im getting the error...

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

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