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

Hello,

How can I delete Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE statement to install on sqlcmd outputfile?

Thanks

Regards

bibi
bibi92Asked:
Who is Participating?
 
ralmadaCommented:
hmm, I'm not sure if that's possible. My question tough is why are you running that option as part of a script? you shouldn't change your server configuration every time you run a script.  Can you please explain why are you doing this? maybe there's a better approach to what you're doing.
0
 
ralmadaCommented:
Can you please rephrase your question? Please indicate what are you trying to do.
0
 
bibi92Author Commented:
Hello,

I try to remove the sqlserver messages in the sqlcmd output file.
For example, If I execute an sp_configure command, in the output file there is a message  Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE statement to install

Thanks

Regards

bibi
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
bibi92Author Commented:
sp_configure xp_cmdshell '1'
Thanks

bibi
0
 
ralmadaCommented:
I know that you're running that command, what I'm not sure is why the message you get from that command is bothering you. To my knowledge there's no way to get rid of that message.  Also remember that the complete command is
sp_configure xp_cmdshell '1'
reconfigure
0
 
bibi92Author Commented:
Exactly thanks, I think too that It isn't possible to remove it from the output file.

Thanks

regards

bibi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.