June 10, 2008 at 3:21 pm
In sql server 2005, I'm trying to generate an element with an xsi:type attribute set on it. (ie ) However I cannot figure out how to do so. I've tried using the "xmlns" keyword, however this generates an element with xmlns:namespace.
I've also tried creating an element with an attribute of "xsi:type". The xml that i get won't display when clicked on because of the following error: "Unable to show XML. The following error happened: 'xsi' is an undeclared namespace. Line 1, position 1405. One solution is to increase the number of characters retrieved from the server for XML data. To change this setting, on the Tools menu, click Options."
If i right click, copy and paste the XML into XMLSpy, the xml is valid. Is there any way that I can see the xml from inside SQL Management Studio? Or am I missing how to declare a namespace of "xsi"type"?
Thanks in advance
June 11, 2008 at 5:46 am
I have encountered the same problem!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply