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.

TIA,

Enmanuel


>Enmanuel,
>
>It's nor clear what you want to be returned. You can choose between XML and a recordset but not both.
>
>>Hi all, I'm relatively new to SQL Server and I'm wondering how can I store the results from a SQL query into a XML file. Anyone can help me with this one? I know the "TO XML" clause of the SELECT statement but I want to be able to save the returned records to disk.
>>
>>
>>
>>
>>ooopsss looks like I screw up! Can somebody please move this thread to the SQL Server forum?