Hi
Not reccomended. SQL Server is a DB Engine, not an XML engine.
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program:
http://www.microsoft.com/mvp Blog:
http://www.msmvps.com/epprecht/ [quoted text, click to view] "Joh" wrote:
> I have a large xml file around 500 MB and I used to insert the data every
> day in one table, the issue is that I only want to use SQL Server to do this
> whole process. No VB and no asp envolve.
>
> Any idea?
>
> Thanks
>
>