Post reply

check if xp_cmdshell is enabled

  • July 8, 2010 at 9:29 am

    #145855

    Hi,

    I'm doing a stored procedure that will enable xp_cmdshell, if it is not enabled yet, on the SQL Server 2005 instance.

    I have the code belloe, to put inside the stored proc (so that it enables the

    xp_cmdshell), but , befour i run this commands i need to know if the option is not already enabled.

    How can i do this?

    Thank you

    EXEC sp_configure ‘show advanced options’, 1

    – To update the currently configured value for advanced options.

    RECONFIGURE

    – To enable the feature.

    EXEC sp_configure ‘xp_cmdshell’, 1

    – To update the currently configured value for this feature.

    RECONFIGURE

  • July 8, 2010 at 9:38 am

    #1190333

    river i don't think you need to check it before hand , just change it...

    if xp_cmdshell is already enabled you just get this message anyway:

    Configuration option 'xp_cmdshell' changed from 1 to 1. Run the RECONFIGURE statement to install.

    so i would have my process change the value no matter what, do it's thing, and then change it back.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

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