Checkout the third part of my XML support and SQL Server article series here.
In this part, I talked about the fundamental problems that we face when integrating XML and SQL Server. Then I talked about the storage options that are available in SQL Server to store XML data. Finally, I presented a demonstration on creating and editing XML documents using SQL Server Management Studio.
This article is published on SSWUG.org.