A friend of mine just asked me, and the solution is to use bulk copy (the command line utility)

Run this at the command prompt from your bin directory :

bcp “SELECT * FROM TABLE FOR XML RAW” queryout c:\table.xml -Sserver -Uusername -Ppassword -c -r -t

Quick, and dirty!