Have installed the latest service packs?

This error was addressed in service pack 1, but I'm not sure if it will help with a 30Mb query.

I also found this article by Pinal Dave[/url]

What is the maximum amount of records you can process without getting this error?

Have you considered using replication?