That's a problem with SQL Server Management Studio running out of memory. How much RAM is on the machine you are running management studio on? How much data is coming back from the query you are running?