How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE
In this article we will discuss How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE.The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system.In order to use XP_CMDSHELL you need to be a system administrator.
Query To Enable XP_CMDSHELL:
04 | EXEC master.dbo.sp_configure 'show advanced options', 1 |
05 | RECONFIGURE WITH OVERRIDE |
08 | EXEC master.dbo.sp_configure 'xp_cmdshell', 1 |
09 | RECONFIGURE WITH OVERRIDE |
Query To Disable XP_CMDSHELL:
04 | EXEC master.dbo.sp_configure 'show advanced options', 1 |
05 | RECONFIGURE WITH OVERRIDE |
08 | EXEC master.dbo.sp_configure 'xp_cmdshell', 0 |
09 | RECONFIGURE WITH OVERRIDE |
