xml viewer

18 Jan 2007 8:47 PM

Chuck P

If I am in 05 Query Designer and I display a column that has xml in it, all I
get is a grayed out field (cell is readonly). I could of sworn that during a
sql class we got an underlined field and if you clicked on it you got the xml
displayed.

Is their an option I have to set somewhere to view the xml or edit it?

19 Jan 2007 7:44 AM

Charles Wang[MSFT]

Hi,
My understanding of your issue is that:
You found that xml data fields cannot be modified in SQL Server 2005 Query
Designer.
If I have misunderstood, please let me know.

It is confirmed that this is a by design issue. Unfortunately by now, xml
data fields have not been allowed to be directly modified in designer;
however, you can use the "UPDATE ... SET .... WHERE..." statement to
manually update the xml field.

I know that this may bring you some inconvenience and appreciate that you
can give Microsoft feedback on this issue via the following link:
https://connect.microsoft.com /sql
Your suggestions will be routed to SQL team and may be resolved in the
next release.

Appreciate your understanding on this.

Please feel free to let me know if you have any other questions or concerns.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

19 Jan 2007 9:03 PM

Simon Sabin

Hello Chuck,

The column has to be an xml data type for you to get the feature where you
click on the xml and it launches the xml in another window.

Try this

select * from sys.objects for xml auto

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

Show quote

> If I am in 05 Query Designer and I display a column that has xml in
> it, all I get is a grayed out field (cell is readonly). I could of
> sworn that during a sql class we got an underlined field and if you
> clicked on it you got the xml displayed.
>
> Is their an option I have to set somewhere to view the xml or edit it?
>

23 Jan 2007 3:23 PM

Chuck P

If I open a New Query window and do
    select * from aNormalTable for xml auto
I get the xml viewable link

If I open a New Query window and do
    select * from TableWithXMLcolumn
I get the link

If I right click on a table and select Open Table
   I don't get the link.

I guess it's some kind of Management Studio feature where you only get the
link if the presented table is not editable.

23 Jan 2007 11:04 PM

Erland Sommarskog

Chuck P (Chuck@newsgroup.nospam) writes:

> If I open a New Query window and do
>     select * from aNormalTable for xml auto
> I get the xml viewable link
>
> If I open a New Query window and do
>     select * from TableWithXMLcolumn
> I get the link
>
> If I right click on a table and select Open Table
>    I don't get the link.

If you think this would be a valuable addition to Mgmt Studio, go to
a http://connect.microsoft.com and file a suggestion for it.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

26 Jan 2007 7:57 AM

Charles Wang[MSFT]

Hi Chunk,
I will try to consult the product team on your concerns. The process may
need a long time, but I will let you know once I get the response. Also, I
recommend that you submit a feedback to Microsoft since sometimes our
consultations may not be guaranteed to get a response from the product
team. Someone is monitoring feedbacks from the http://connect.microsoft.com
and will route the feedbacks to the related team so that they can give an
explanation or fix the issue.

Sincerely yours,
Charles Wang
Microsoft Online Community Support