Is there a way in SQL Server Management Studio to view field data in a multi-line editable field?

Question

I have a database that I am viewing with SQL Server Management Studio 2008.

I right-click on the table and choose edit top 200 rows.

I tab over to my "SerializedXML" varchar(max) field that has 100s of lines of data in it but I am only able to move back and forth in it with my cursor in a tiny one-line textbox.

I remember there being no alternative to this back in SQL Server 2000 Enterprise Manager, but thought it might have changed by now.

Is there any way I can view/edit this field in a mutli-line textbox?

Answer 1

I don't think it's possible, I looked around for a while and gave up (was storing XML also). Only thing I can suggest is copy-paste between notepad and the cell.

Answer 2

this is already discussed.

http://stackoverflow.com/questions/53026/how-to-easily-edit-sql-xml-column-in-sql-management-studio

As everybody says over there, I will vote to write small tool.

Here is one third party tool

http://www.altova.com/xmlspy/sql-server-xml.html

may be give try to trial version.