From within Query Analyzer, does anyone know how to redirect the results of a stored procedure to an XML file?

I have a stored proc that returns 3 tables. What I’d like to do is type something along the lines of:

     EXEC MyStoredProc  @Parm1, @Parm2   OUTPUT TO C:\XMLResults.XML

There are new FOR XML clauses in SQL 2005, but from what I've seen, they seem to apply to individual SELECT statements.

I know that I can write a few lines of code in ADO.NET to do it. Just curious if I can do it within SQL Server.


Kevin