Generate XML File in SQL Server 2005

I want to generate XML file which will be stored in C: of SQL Server 2005 machine. How to generate XML file in SQL Server 2005It is not recommended to access local discs of the SQL Server. It will require admin permissions and also it is a potential security vulnerability.
You can create XML using different techniques, starting from select... for XML to constructing XML using .NET integration, depending on data source for XML and required XML structure. Then you can store constructed XML inside database, or send it to client that will store it wherever needed.

If you want to get more help on constructing XML on SQL Server, please provide description on how do you get the data for XML, expected structure of XML, and samples of both.|||Create a assembly of ur own and use that assembly in SQL Server.

Don't forgot to save that assembly inside the \binn folder of ur sql server

http://www.sqldbatips.com/showarticle.asp?ID=23

:)