Hi Guys , I need to store what my sql queries return in XML format...I managed to display the XML format by adding
'for XML auto' line to the end of each query..I was able to save that as .xml file just by right-click and hiting save as...

However, this isnt an efficient way to do it ...therefore , I am looking for a piece of code (I did not know how to get the sql 'save' to do the job ) which will enable me to generate .xml files and store them somewhere automatically .....--I am using the queryAnalyzer of msSQL2000 to write my queries--

Help would be very appreciated ....

Thanks in advance ....

~TAT TWAM ASI~