Yes I know it's odd what I'm asking :) but I still got this SP that returns several RS to an ADO object and I'm getting an error trying to read the second RS with the ADO NextRecordset method because the 2nd RS it's a SQL table data type variable and therefore closed after the SP terminate executing. I thought of just save the recordset into a temp file and read it from there.

Enmanuel


>I still not sure why do you want to retrieve recordset instead of getting XML directly from SQL Server using 'FOR XML' clause. Anyway, you can conver returned cursor into XML using XMLTOCURSOR() function.
>
>>Sorry if I did not make myself clear. All I want is to save the records returned by the select statement into a XML file in the client computer. Let's say I have the following statement:
>>
>>

>>  Select * From Employees
>>

>>
>>Then I want all the records from the Employees table to be saved into a XML file named C:\myXMLFiles\Employees.xml, for example.
>>