Insufficient memory for OPENXML query

Probable cause 

The memory used by an OPENXML query may be proportional to the size of the largest subtree in the xml document that has nodes referred to by a single row in the result. Try increasing the cache size or rewriting the query so that rows refer to smaller subtrees.