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:

Anvesh Patel

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.