Thanks, but the aforementioned patch has already been applied with no difference.

Dave.

I wish they had been written that recently, I believe a most were written for SQL Server 7 which may be another issue but all SPs UDFs and Views need...

Thanks, I had come to the conclusion that there has to be a memory leak somewhere so I am currently trying to find and fix the problem, for now I...

It is a 64bit server, and my two problems are that my application slows down considerably when the server memory usage hits 6gb, and that nothing reports that SQL server...

Sorry I should have mentioned that the server has 8 gig of memory with SQL Server only allowed to use 6 gig. I am slowly rewriting the appalling stored procedures...