David Klug (9/4/2008)
Have you considered moving to SQL Server 20008 for the Report Server? It is no longer restricted by memory and on initial tests I've run, I've been able to generate 70,000+ page reports without issue.
Upgrading to SQL Server 2008 is not a quick solution: costs, time, testing and so on.
Things were running OK last week. This week they are not.
Rob