Pages

Saturday, September 21, 2013

SQL SERVER – Enable xp_cmdshell using sp_configure | Journey to SQL Authority with Pinal Dave

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. ---- To allow advanced options to be changed. EXEC sp_configure 'show advanced options', 1 GO ---- To update the currently configured value for advanced options. RECONFIGURE GO ---- To enable the feature. EXEC sp_configure 'xp_cmdshell', 1 GO ---- To update the currently configured value for this feature. RECONFIGURE GO Reference : Pinal Dave (http://blog.SQLAuthority.com) Continue Reading...

Source: SQL SERVER – Enable xp_cmdshell using sp_configure | Journey to SQL Authority with Pinal Dave