"Oleg Tkachenko [MVP]" <oleg@NO!SPAM!PLEASEtkachenko.com> wrote in message
news:eM%23LU9CDEHA.3016@TK2MSFTNGP11.phx.gbl...
> Matt Frame wrote:
>
> > What is the best method to set the XML root using ExecuteXmlReader when
I
> > use either a stored procedure that returns XML or command text using FOR
> > XML?
>
> You can use SqlXmlCommand instead of SqlCommand. SqlXmlCommand has handy
> RootTag property.
> --
> Oleg Tkachenko [XML MVP, XmlInsider]
> http://blog.tkachenko.com

Matt Frame wrote:

> What is the best method to set the XML root using ExecuteXmlReader when I
> use either a stored procedure that returns XML or command text using FOR
> XML?

Matt Frame wrote:

> Okay call me stupid, but I can't find any references to the SqlXmlCommand
> object in the .Net documentation. I am using .Net 1.1 and VS.Net 2003. I
> did a word search in the .Net studio and came up with no hits. I had seen
> sample using that property and this is why I posted the question. Is this
> in some special reference that needs to be done and not part of the .Net
> Framework?