thanks a lot noam, i discovered that yesterday. after looking at the trace i realised that having over a 1000 sp's creating temp tables with names such as #tmp or...