"Jeeves De Veyra" <me@jeevester.com> wrote in message
news:%23%23Dh6aDrEHA.2924@TK2MSFTNGP12.phx.gbl...
> Hello,
>
> I have a problem with one of my SPs with a FOR XML EXPLICIT line. I tried
> it
> on a SQL Server 2000 installation and it works fine.
>
> Anyway, I've tried it with some of the MSDE GUIs (both standalone's and
> WebServer Based) and it doesn't come up with the output. On the MSDE
> version
> when I run it through the GUI Query Analyzer versions, it seems to run, it
> spits out the non XML Select statements and it shows the "rows affected"
> messages and it doesn't show any error messages.
>
> Any idea what's happening?
>
> Jeeves
>
>

"Greg Low [MVP]" <greglow@lowell.com.au> wrote in message
news:uxeJ29ErEHA.324@TK2MSFTNGP11.phx.gbl...
> Hi Jeeves,
>
> It just sounds like the tools aren't rendering the XML output. That's
> probably not that surprising. The MSDE won't be the problem. It does it
just
> fine so it will be ok with your apps.
>
> HTH,
>
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
>
> "Jeeves De Veyra" <me@jeevester.com> wrote in message
> news:%23%23Dh6aDrEHA.2924@TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I have a problem with one of my SPs with a FOR XML EXPLICIT line. I
tried
> > it
> > on a SQL Server 2000 installation and it works fine.
> >
> > Anyway, I've tried it with some of the MSDE GUIs (both standalone's and
> > WebServer Based) and it doesn't come up with the output. On the MSDE
> > version
> > when I run it through the GUI Query Analyzer versions, it seems to run,
it
> > spits out the non XML Select statements and it shows the "rows affected"
> > messages and it doesn't show any error messages.
> >
> > Any idea what's happening?
> >
> > Jeeves
> >
> >
>
>