469,639 Members | 1,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,639 developers. It's quick & easy.

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 2005
Jan 24 '07 #1
2 5685
almaz
168 Expert 100+
It 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.
Jan 24 '07 #2
radcaesar
759 Expert 512MB
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

:)
Jan 24 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by CG | last post: by
8 posts views Thread by Phil Lee | last post: by
11 posts views Thread by imani_technology_spam | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.