In this article you saw how to take advantage of the new XML
data type and XML schema collection database object within SQL Server 2005 to save
InfoPath forms as strongly typed XML to a database table. With XML schema
collections you can define multiple XML schemas on one XML table column and,
thus, also save InfoPath forms with different XML schemas to one XML table
column.
Due to limitations of XML schema collections in SQL Server,
you will not always be able to use typed XML table columns to save your
InfoPath forms in, so you may have to resort to using untyped XML table
columns.
Finally, you saw how to use an ASP.NET page to submit your
InfoPath forms to SQL Server and save them as XML.