I found a tutorial on viewing XML data-type fields within Management Studio here:
About a third of the way down, it shows a screen shot of a column of XML fields in blue, as hyperlinks. And it shows another pop-up window that appears if you click a the hyperlink. It appears this window lets you expand and collapse nodes within the XML, which would be very useful for me.
However, my Management Studio doesn't behave that way. There's no hyperlink, and when I hover over the XML field, it just displays the results in the same format as "help text": it's flat, with no formatting or ability to manipulate it.
Is the above link maybe from a beta version that got dumbed down? Or is there some full-featured way to examine the contents of an XML field that I haven't found yet?
Thanks a lot!