The stored procs does not use any cursors. It uses #temp tables other than that there are no major reasons to fill up the memory. The server has tons of...

I am having the same trouble. Any updates on this topic. I have the latest service pack but it still get the error randomly.