I need to increase the non-interactive desktop heap by 256 KB or by 512 KB due experiencing some strange problems like when running xp_cmdshell, (for example exe's stops being called properly and even basic ones stop working), the server tends to have to be rebooted to fix these in the past.
Would anyone know if there a way to fully apply this fix without the need for a server reboot.
eg could MSSQLSERVER Service be restarted instead of a server reboot to apply the changes.
The kb does not say if a server reboot is needed or not.
If anyone can reply before Saturday then I will love you forever (I'm in work tomorrow).
Ps I need to do this on SQL 2000 and 2005 Servers using Windows Server 2003.
Thanks guys for helping me. I increased the heap to 1024 exactly as per the MS KB article but I still found the same problem - When I run any exe using xp_cmdshell using sql query analyser is still just gave an output of NULL.
Not to worry, I've done this on 5 servers so far and rebooted them. I might just have to see how it goes for a while now.
Thanks again for your help