magicmushroom
Programmer
Hi - I'm running SS2005 on 2003. I'm tring to use xp_cmdshell to run 'taskkill' to kill a process. I keep getting 'Access denied'. The SQL account that is running xp_cmdshell is in the server admin group. If I log on using that account I can kill the process using command prompt.
Interestingly, if I run the process via xp_cmdshell ( i.e. exec xp_cmdshell 'c:\foo.exe' ) I can kill it using exec xp_cmdshell 'taskkill /F /IM foo.exe'.
I can't fathom this behaviour. Can anyone assist?
thanks - M
Interestingly, if I run the process via xp_cmdshell ( i.e. exec xp_cmdshell 'c:\foo.exe' ) I can kill it using exec xp_cmdshell 'taskkill /F /IM foo.exe'.
I can't fathom this behaviour. Can anyone assist?
thanks - M