However, I need to export data from SQL server and drop it into an XML file. The table structure would be a de-normalized view, one column per field in the XML file to be populated with values.

How to import or export diagrams with SQL Server? Information about the diagrams is stored in the dtproperties table. Basically to import or export a diagram, you simply need to import or export the ...