>I am trying to display a XML column coming from a SQL 2005 table in the nicely formatted layout that I can see if I open it within SQL Management Studio.
>
>I do not have an XSD file.
>
>I have used SPT to get a table with a single column which is a memo datatype. When I open this, the XML is there, but as text with no line breaks etc, and very difficult to read.
>
>I have tried using XMLTOCURSOR and get parsing errors, but nothing is reported as wrong when I view in SQL.
>
>Are there any ways of viewing this XML in a properly formatted layout, say in an edit box (this is for viewing only by the way).
>
>Thanks
>Simon
Simon,
Check
Re: XML Tree Edit/add Thread #
1199893 Message #
1199954See also
View XML in WebBrowser Control
If it's not broken, fix it until it is.
My Blog