Post reply

sp_configure 'xp_cmdshell', 1

  • April 22, 2008 at 7:24 am

    #123450

    "EXEC master.dbo.sp_configure 'xp_cmdshell', 1

    RECONFIGURE"

    I need to run this everytime the server is rebooted, Anyway to make it permanent?

    Thank you in advances.

  • April 22, 2008 at 11:32 am

    #805656

    You can use master.sys.sp_procoption by passing the name of a stored procedure which you want to execute at startup. In that, another S.P. you can specify your command.

  • April 22, 2008 at 12:00 pm

    #805670

    jjarupan (4/22/2008)

    "EXEC master.dbo.sp_configure 'xp_cmdshell', 1

    RECONFIGURE"

    I need to run this everytime the server is rebooted, Anyway to make it permanent?

    Thank you in advances.

    Go to Surface Area Configuration for Features

    click the checkbox next to Enable xp_cmdshell.

  • April 22, 2008 at 12:47 pm

    #805693

    Thank you for all.

    It work great in all database except one (the one that I need).

    Now I think the problem come from third party software disable xp_cmdshell.

    Thank again.

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

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