Re: XML to SQL2005.net2.0 unattended

Tech-Archive recommends: Fix windows errors by optimizing your registry

Yes, the sp_xml_preparedocument is native.
OPENXML is reasonably well documented in Sql Server's Books On Line.
Enter "OPENXML function" in the Index, and follow the link at the bottom of
the article for "Querying XML Using OPENXML".

I did some research on this and using OPENXML is not recommended on
anything but small xml files due to the fact OPENXML is very memory
intensive which could bring the system down. Not good.

"OPENXML is very memory intensive. The pointer returned by the system
stored procedure sp_xml_preparedocument is a memory pointer to a COM
XML document object model. So, you must be careful not to load large
XML documents into memory with OPENXML because it may overload your
server's memory."

here is the link to this citation: http://articles.techrepublic.com.com/5100-9592-6138776.html




.

Relevant Pages

  • Re: OPENXML performance
    ... To slightly clarify Mingqing' statements, ... > available to the OPENXML construct over an XML document operation. ... It is one eighth of the available MAIN memory ...
    (microsoft.public.sqlserver.xml)
  • Re: XML to SQL2005.net2.0 unattended
    ... OPENXML is reasonably well documented in Sql Server's Books On Line. ... the article for "Querying XML Using OPENXML". ... If you try to use an XmlDocument, you would encounter the same problem, because the XmlDocument also loads the entire document into memory. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL Adapter
    ... Using namespaces in OPENXML is fraught with danger! ... Here is an example SQL that works with your Xml document ... My advice is to remove the namespace from the BodyRoot schema. ... If I leave the namespace declaration in there, ...
    (microsoft.public.biztalk.general)
  • Re: SQL and XML
    ... OPENXML is a dataset provider, which can be used in t-SQL statements ... It can take a internal representation of an XML document and ... sp_xml_removedocument to remove the internal representation. ... All details about attribute & element centric mapping, flags, colpatterns, ...
    (microsoft.public.sqlserver.programming)
  • Re: Data File
    ... Could you source file possibly be XML? ... OPENXML provides a rowset view over an XML document. ...
    (microsoft.public.sqlserver.programming)