Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Saving XML output

Author  Topic 

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2002-05-20 : 01:24:56
Hi,
Using For XML/Templates we can get the output in XML format instead of a Record set. My problem is that, i want to store this XML format as XML file on the Hard disk. Is it possible through SQL Server?
Thanx in advance.


---------------------------
Sandesh - The Messanger

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2002-05-20 : 04:33:41
If you are using SQL2K and IIS this can be acomplished using the "Configure SQL XML support in IIS" wizard provided in the start menu.

Go to Top of Page

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2002-05-20 : 04:55:01
Rihardh,
If you want to access the database table through address bar of the browser, then you have to configure SQL XML in IIS.
But here i want to store the XML output in the file on Hard Disc.

---------------------------
Sandesh - The Messanger

Edited by - sandesh_moghe on 05/20/2002 05:51:51
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-20 : 09:21:15
Try this:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=9336

Go to Top of Page
   

- Advertisement -