My company is considering storing XML strings of maybe 10 or 20 thousand bytes in SQL Server 2005. We don't know much of anything about it yet. So first:
1. Would we store the whole thing as a long string, or does SQL Server support storing it as actual XML nodes?
2. If stored as one long string, how would you store it? varchar? blob?
3. Does SQL Server provide it's own support for viewing the string as XML? Some sort of UI, expandable nodes, etc.?
Thanks a lot?