July 8, 2010 at 9:29 am
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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply