Hi , I am facing the same issue
In my XML I have the following data:
<Transaction xmlns="http://www.abc.com/xdata/100" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
and in SQL i am declaring the namespace as:
;WITH XMLNAMESPACES...