>Hi all,
>
>We need to import an XML with schema into a new database on SQL Server 2008. It appears there are some methods of doing this that seem a bit involved. Since this is basically a one time move from one data source into XML and then into SQL server it isn't very appealing to go through 38 steps of creating stuff. I would have hoped there was a import from xml file in SQL server but can't find any such thing.
>
>Does anyone know of a simple import solution?
>Thanks
>Tim
http://support.microsoft.com/kb/316005http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspxNone of them tested :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.