If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: save to xml

Hi,

is it possible to save the results from a query to an xml file directly from sql server (so without the use of any visual studio languages). What I would like to do is that when a user on our site completes an order, this order is saved as an xml file.

yes, I know about the xml options. But those options format your query results. What I want to do is save these results to a physical xml file. The name of this file should be dynamically assigned. Do I use some kind of dts package or are there functionalities in for example SQLXM?

Thanks Brett, thats what I thought. But perhaps I need to rephrase my question a bit: does anyone have some experience in using xml with SQL Server. What are the pros and cons? Did you use it directly or through an application?