Export Data to Xml File

Hello everyone,
I need to save data into an xml file. Now I do this with Visual Basic using
the ado-recordset method 'Save'. I'd like to do this task with a sql server
stored procedure.
Does anyone know if it is possible, and how?
--
Thank you everyoone,
Walker BohAs mentioned in a post yesterday: You can use the sp_OA stored procs (but
you need to have Admin rights).
Best regards
Michael
"Walker Boh" <WalkerBoh@.discussions.microsoft.com> wrote in message
news:FD2C2B46-F3C5-4206-93BF-D6D6D89D9DE0@.microsoft.com...
> Hello everyone,
> I need to save data into an xml file. Now I do this with Visual Basic
> using
> the ado-recordset method 'Save'. I'd like to do this task with a sql
> server
> stored procedure.
> Does anyone know if it is possible, and how?
> --
> Thank you everyoone,
> Walker Boh|||Thanks, it works.
"Michael Rys [MSFT]" wrote:

> As mentioned in a post yesterday: You can use the sp_OA stored procs (but
> you need to have Admin rights).
> Best regards
> Michael
> "Walker Boh" <WalkerBoh@.discussions.microsoft.com> wrote in message
> news:FD2C2B46-F3C5-4206-93BF-D6D6D89D9DE0@.microsoft.com...
>
>|||Ok, I tried these sp_OA.. and they worked as I wished, save they used more
time than the vb program.
I'd like to know if there is some T-SQL code to accomplish this task
"Michael Rys [MSFT]" wrote:

> As mentioned in a post yesterday: You can use the sp_OA stored procs (but
> you need to have Admin rights).
> Best regards
> Michael
> "Walker Boh" <WalkerBoh@.discussions.microsoft.com> wrote in message
> news:FD2C2B46-F3C5-4206-93BF-D6D6D89D9DE0@.microsoft.com...
>
>|||Unfortunately, there is no better way than the two mentioned below, save you
writing your own extended stored proc.
In SQL Server 2005, I think you could use the CLR to write such a function
in a cleaner way.
HTH
Michael
"Walker Boh" <WalkerBoh@.discussions.microsoft.com> wrote in message
news:7FDC37F1-912C-4F8E-9C3E-4778DCDDB0D6@.microsoft.com...
> Ok, I tried these sp_OA.. and they worked as I wished, save they used more
> time than the vb program.
> I'd like to know if there is some T-SQL code to accomplish this task
> "Michael Rys [MSFT]" wrote:
>sql