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