I have the next the problem: I have an aplication developed in Java and when i call to store procedures I always put the sentence nocount on at the begining and nocount off at the end. I insert that sentence because somebody told me that it improves the execution for many things, but i have one store procedure in particular that returns to me with a OutOfMemoryException. However if I delete the nocunt on from the sp, the execution works, so what is the best change???? Even i have run the same aplication with the same jdbc and web server and database and it works!!!! Could be some parameter of the database that is not set in the databases in the same way?????