Home Forums SQL Server 7,2000 General Dynamic SQL for variable TableName with OpenXML RE: Dynamic SQL for variable TableName with OpenXML

  • Has the XML you are trying to work with got a namespace defined? If it has you have to set up the namespace in the sp_xml_preparedocument arguments.

    My first and only foray into XML taught me this after much hair extraction!

    Tim