Persisting XML

Hi all,
I would like to save the output of a FOR XML stored procedure to a file on my hard drive with a filename of my choosing. Can anybody point me in the write direction on how to do this. (I've got the FOR XML sproc written, I just need help figuring out ho
w to persist it to a file. Thanks.
JT
Hi JT,
I noticed you make another post with topic 'Persist Sproc OUTPUT' in the
newsgroup: microsoft.public.sqlserver.programming. I found an community
member has added his reply to that thread and I will add my reply if you
have follow up questions to that thread
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||See the thread entitled "extracting results of XML stored proc to file"
started by Mike UK in this newsgroup.
Cheers,
Graeme
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
www.microsoft.com/mspress/books/6137.asp
"JT" <JTnospam@.verizon.net> wrote in message
news:A3758B34-4AC8-4675-8326-319C40508CFF@.microsoft.com...
> Hi all,
> I would like to save the output of a FOR XML stored procedure to a file on
my hard drive with a filename of my choosing. Can anybody point me in the
write direction on how to do this. (I've got the FOR XML sproc written, I
just need help figuring out how to persist it to a file. Thanks.
> JT
|||Thanks Graeme.
JT

Perrormance Monitor

Using Windows performance monitor, I noticed that the
Output Queue Length under my Network Interface is showing
a very high number of 4294967291. I read somewhere that
if this is longer than 2, then delays are being
experienced and a bottle neck exists. This is a Win2K
server running MS SQL 2000. What can do to determine the
source of this bottleneck and correct it?
EmmaThat would indeed be a high number. However, PerfMon counters sometimes get
messed up and I don't believe that's really the number...
Do you have the ability to reboot the box?
--
Brian
"Emma" <eeemore@.hotmail.com> wrote in message
news:025301c3aad7$2213a830$a101280a@.phx.gbl...
> Using Windows performance monitor, I noticed that the
> Output Queue Length under my Network Interface is showing
> a very high number of 4294967291. I read somewhere that
> if this is longer than 2, then delays are being
> experienced and a bottle neck exists. This is a Win2K
> server running MS SQL 2000. What can do to determine the
> source of this bottleneck and correct it?
> Emma|||I can reboot the box after business hours. I will do that
and check the number again.
Thanks
>--Original Message--
>That would indeed be a high number. However, PerfMon
counters sometimes get
>messed up and I don't believe that's really the
number...
>Do you have the ability to reboot the box?
>--
>Brian
>
>"Emma" <eeemore@.hotmail.com> wrote in message
>news:025301c3aad7$2213a830$a101280a@.phx.gbl...
>> Using Windows performance monitor, I noticed that the
>> Output Queue Length under my Network Interface is
showing
>> a very high number of 4294967291. I read somewhere that
>> if this is longer than 2, then delays are being
>> experienced and a bottle neck exists. This is a Win2K
>> server running MS SQL 2000. What can do to determine
the
>> source of this bottleneck and correct it?
>> Emma
>
>.
>|||Emma,
How did you resolve your problem with the OUTPUT QUEUE LENGTH- as I am having the same issues on my ISA servers Rebooting the server does not seem to help as it shoots right up again. this does appear to be an ISA specific issue but it would be helpful to know why.
regards,
Ade
-- Emma wrote: --
I can reboot the box after business hours. I will do that
and check the number again.
Thanks
>--Original Message--
>That would indeed be a high number. However, PerfMon
counters sometimes get
>messed up and I don't believe that's really the
number...
>>Do you have the ability to reboot the box?
>>--
>>Brian
>>"Emma" <eeemore@.hotmail.com> wrote in message
>news:025301c3aad7$2213a830$a101280a@.phx.gbl...
>> Using Windows performance monitor, I noticed that the
>> Output Queue Length under my Network Interface is
showing
>> a very high number of 4294967291. I read somewhere that
>> if this is longer than 2, then delays are being
>> experienced and a bottle neck exists. This is a Win2K
>> server running MS SQL 2000. What can do to determine
the
>> source of this bottleneck and correct it?
>> Emma
>>.
>