472,334 Members | 1,486 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,334 software developers and data experts.

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 5734
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
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


Jan 24 '07 #3

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

Similar topics

by: CG | last post by:
I am looking for a way to parse a simple log file to get the information in a format that I can use. I would like to use python, but I am just...
by: ferbar | last post by:
Hello all, This may sound pretty basic stuff.. but I'm working on a socket example whose client seems to work fine, but the server doesn't send...
by: anna | last post by:
Map, generate, and maintain 50% of your .NET application code, namely your business and data objects. Use these objects in ASP.NET, Windows Forms,...
by: Phil Lee | last post by:
I'm sure this is possible but I just can't see how to do it. I want to add schemas to my solution and have C# classes automatically generated from...
by: Martin Widmer | last post by:
Hi guys I am looking for the best way to generate new reports with reporting services for SQL server 2005. The reports will be generated...
by: Learner | last post by:
Hello, We are using ActivePDF toolkit to generate reports in our web application. We are using ASP.NET 2.0 and SQL Server 2005. We are able to...
by: imani_technology_spam | last post by:
The table in the database has a field called LabID. That field is an integer and consists of the year plus a counter. For example, the first...
by: Mark D Powell | last post by:
I had thought that I had posted this yesterday but since I cannot find it here we go again. I have searched the archives but either the code I...
by: Yas | last post by:
Hello, I have the following table with 4 columns.... firstname, lastname1, lastname2, EMAIL Table has user names and email, I would like to...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.