Monday, March 5, 2007

Enabling/Disabling xp_cmdshell

In order to use xp_cmdshell in the QA, do the following steps:
  1. sp_configure 'xp_cmdshell','1' -- Set it enabled
  2. reconfigure -- apply the changes in db
Now you can run xp_cmdshell.

If you want to disable it, do followings:
  1. sp_configure 'xp_cmdshell','0' -- Set it disabled
  2. reconfigure -- apply the changes in db

No comments: