Is anyone familiar with exporting XML documents from SQL Server 2000? I have been messing with it and looking at MSDN. I have been able to run a query with the result returned as XML. However, I don't know how to export the result on the server as a text (XML) document using a stored procedure.

Basically it boils down to taking a result and exporting the result to a file.

Also, another issue I am having is that my results are truncated after 256 characters. How can I format the result to use an unlimited size field?