Writing an xml file from sql server 2000 19 February 2006 (0) sp_makewebtask @outputfile = ‘c:\sqlserveroutput\myxmlfile.xml’, @query = ’select top 1 * from myTable for xml auto’, @templatefile = ‘c:\temp\mytemplate.tpl’ myTemplate.tpl = SHARE: