SQL Server: Script to Enable and Disable XP_CMDSHELL Configuration

In this post, I am sharing a script to check, enable and disable XP_CMDSHELL on the SQL Server.
This script is very useful for those professional, Who are interested in using command line utilities with SQL Server.

If you want to use command line tool, you should enable this XP_CMDSHELL configuration.

First, Check XP_CMDSHELL is enabled on the server:

Script to enable and disable XP_CMDSHELL:

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from dbrnd.com

Leave a Reply

2 Comments on "SQL Server: Script to Enable and Disable XP_CMDSHELL Configuration"

Notify of
Sort by:   newest | oldest | most voted

I’m really enjoying tthe design and layout of your site.
It’s a very easy on tthe eyes which mkes it much more pleasant for me
to come here and visit more often. Did you hire out a
developer to create your theme? Great work!


Whhen someone writes an post he/she maintains the idea of a
user in his/her mind that how a user can know it. Therefore that’s why this article is amazing.