Post reply

Cmd Shell

  • March 15, 2013 at 4:58 am

    #290816

    Hi Team,

    Is there any query to find cmd shell is enabled to disabled.

    i want to know the current status.

    Please help...

  • March 15, 2013 at 5:03 am

    #1597425

    sp_configure show_advanced_options, 1

    reconfigure

    Then just run sp_configure

    Look for the xp_cmdshell "configured" value.

    If it's 0, its disabled, if its 1, its enabled.

  • March 15, 2013 at 5:12 am

    #1597428

    select name, case value when 0 then 'Disabled' when 1 then 'Enabled' END AS Status, CASE value_in_use WHEN 0 THEN 'Disabled' WHEN 1 THEN 'Enabled' END AS RunningStatus from sys.configurations where name = 'xp_cmdshell'

    Will return the config value and the value which is in use, someone might have changed the value but not actually hit reconfigure yet to make it change to running or disabled.

  • March 15, 2013 at 5:21 am

    #1597432

    Thnak u,

    Really Helpful.

    Thanks a LOT:-)

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

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