When I try to export a TABLE to Excel, it works just fine.
But when I try to export a VIEW, I get some warning messages beforehand (see attached file), then it hangs, and creates a HUGE tempdb file that would keep growing if I didn't stop the SQL service. Am I missing something about exporting a view? It's a very simple view, and works just fine when I query it. I wouldn't worry if the process was SLOW, but to be creating a seemingly infinite tempdb file (10GB+) seems to be a problem.