Had the same error In 2005. Moved the query to 2008 and ran again. Error did not recur.

Mine returned 4.9 million rows, so I have to believe it is some form of "Out Of Memory" error in 2005.

Hope that helps.