In SQL Server you can use an XML datatype and map it to relational columns using an AXSD schema.
Mapping between XML and relational storage By using an annotated schema (AXSD), the XML is decomposed into columns in one or more tables. This preserves fidelity of the data at the relational level. As a result, the hierarchical structure is preserved although order among elements is ignored. The schema cannot be recursive.
from MSDN
However I cannot find any documentation on how to do this - or even a good page about AXSD.
Anybody got any good AXSD information. it seems very appropriate to what I want to do (temporarily use XML until i can migrate to something like nHibernate, but still allow a column view of certain pertanent data fields.