[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

How to view XML fields in Management Studio (2005)?

Dear Experts,

I found a tutorial on viewing XML data-type fields within Management Studio here:

http://www.15seconds.com/issue/050803.htm

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!
--BrianMc1958
0
BrianMc1958
Asked:
BrianMc1958
  • 7
  • 6
1 Solution
 
Atlanta_MikeCommented:
First you have to show the results in a grid. Next, verify in the Query Results, Results to Grid that XML data is set to a value greater then the length of your XML string.

Keep in mind that it must be a properly formed XML string.

The rest is automatic.
0
 
BrianMc1958Author Commented:
Do you do anything all day long other than sit around and wait to answer my questions?
0
 
BrianMc1958Author Commented:
Actually, all that looks OK.  I'm using the AdventureWorks sample db, and the max size for XML returned is 2MB, which is presumably a lot bigger than their sample.  Am I doing something else wrong?  
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
BrianMc1958Author Commented:
I should say I have a trial version (with SP1 installed on top of it.)  Any chance the trial version lacks that capability?
0
 
Atlanta_MikeCommented:
Go to Options in Management Studio, Text Editor, XML, General, Enable single-click URL navigation
0
 
BrianMc1958Author Commented:
Still no go.  That was the default.  Again, the XML field doesn't show up as a URL at all.  Do you have SP1 installed?  Maybe it changed?

Thanks again...
--BrianMc1958
0
 
Atlanta_MikeCommented:
Nope, I installed the SP1 as soon as it came out on our Dev box. Works just fine?

Try copying the text from the results and pasting it into some XML tool like XML Spy and see if it is recognized as well formed. It should be working.
0
 
BrianMc1958Author Commented:
Well, XML Spy says it's well formed.  

Another clue:  At the bottom of the grid, it says "cell is read only", and the XML column is grayed out.  I don't know if that might be a cause or a symptom...

Any more ideas?

--BrianMc1958
0
 
Atlanta_MikeCommented:
Are you trying to do an open table? OR running a query from Management Studio?
0
 
BrianMc1958Author Commented:
Oh.  I have the table opened.  I just right-click on the table within Management Studio and select Open Table.  Is that wrong?
0
 
Atlanta_MikeCommented:
Yep.. it doesn't work like that.

Do a select columnname from tablename. It will only work in this fashion.
0
 
BrianMc1958Author Commented:
Wow.  Thanks a lot!  It finally works--and it works beautifully!
--BrianMc1958
0
 
Atlanta_MikeCommented:
Cool, isn't it?
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now