sql server new users: I simply want to load an XML (either from a file or text),
then validate it against an XSD (file or text).

1.) I have NO idea how to do this, please help.

2.) Can this be done strickly in SQL Server 2005 (or do I need VS2005)

It can be done in SQL 2005, without VS.NET 2005. You can use XML data type
when creating a table and specify it is validated against a schema from XML
schema collections. When you insert data, it is validated against the
schema. Do please check the XML data type in SQL 2005 Books OnLine.

--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com

[quoted text, click to view]