In some shops \ cases this feature may be turned off as part of the security regulations. You may need to flip xp_cmdshell on to perform a piece work and then flip the bit back when the work is done. You can also tweak the code to flip the bit off again when done. Simple, non complex script but very effective in an automation task. The script uses sys.configurations to check the bit set for the xp_cmdshell feature, if the value = 0 we turn it on. I hope you will find some use for the code.
2016-10-24
1,056 reads