I have tried to limit the memory in the server properties under memory. this did not help

SSC

Thanks for your reply. As for the box OS, it is a laptop so do not want to use Win Server. When i run the stored proc...