I want to export data from a database to a XML-file. How can I do this using only T-SQL (with the FOR XML-clause), SQL-server 2000 and Windows 2000. This has to be a job within SQL-server.
I can write the select-statement, but I can't get it into a file. The data can be very long (more than 8000 characters).