March 15, 2013 at 4:58 am
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
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy