Hi Russell The actual problem is that if I run any xp_cmdshell command it outputs : NULL When I reboot the server, it fixes this - this why I've been asked to check the SQL accounts. Obviously that can't be the cause.
Would you have any idea why this happens. We find that we have to reboot servers once every two or three months.
The above example using dir.exe is just an example to say that is should output something but if its doesn't then I'm not able to check why some of my companies bespoke exe's are not working and so can never get to the bottom of why the company exe's are not working.