Create XML file with SS Management Studio Express

Hi Folks,

I have this problem using SQL Server Management Studio Express.
When browse query/table with XML type column I cannot create manualy XML field.
Is that possible using built-in XML editor ?

I make following steps:
1. Use AdventureWorks example Database
2. Create New Query on Person.Contact table

SELECT ContactID, Title, FirstName, AdditionalContactInfo
FROM Person.Contact

3. Execute query
4. Then : first 10 records contain XML data in AdditionalContactInfo field
5. I cannot insert manualy new XML data into record 11,12 e.t.c

I thing it is possible by built-in XML editor, but HOW ?

Is it possible to change such field using MS Access version 2002 ?

Thanks in advance !

Hi Aleko_b,

You can't directly edit the XML with SQL Server Management Studio or the Express version either. We are considering this functionality in a future release. You need to construct an INSERT statement within the T-SQL Editor and copy/paste the XML from the XML editor.

As far as Access 2003 is concerned, you will want to create a Linked Table via ODBC to the table in question. The XML field will look like a Memo field that you can edit for changing the contents of the XML field. Just be careful not to modify the tags. ;-)

Thank you,
Bill Ramos, Lead PM, SQL Server Manageabilty

|||

I just discovered the "XML Editor" today. Is there an instruction guide or a list of supported features available?

TIA,

barkingdog