You can validate multiple elements in an XML file using .Net. But not using SQL XML.

I don't have the environment to test this, but I think that the code in this article will do it:

http://codedisplay.com/validate-xml-file-aganist-xsd-using-asp-net-c-vb-net/