Surface Area Configuration

How to Enable / Disable Xp_cmdShell in SQL SERVER? TIP #82

Friends, Sometimes it might be possible that you have to run dos command from SQL SERVER. In such situation you have to enable the xp_cmdShell option of  sql configuration. To enable this we can write following statement EXEC sp_configure ‘show advanced options’, 1;GORECONFIGURE;GOEXEC sp_configure ‘xp_cmdshell’, 1;GORECONFIGURE;GO Just wanted to share that it can be a …