SQL SERVER – Fix : Error : Msg 9514, Level 16, State 1, Line 1 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s). | Journey to SQL Authority with Pinal Dave

Error: Msg 9514, Level 16, State 1, Line 1 Xml data type is not supported in distributed queries. Remote object 'OPENROWSET' has xml column(s). This error happens when XML Data Type is queried using OPENROWSET. It was very interesting for me to find the workaround for this. Fix/WorkAround/Soulution: I CAST the retrieved the XML data… Continue Reading...

Source: SQL SERVER – Fix : Error : Msg 9514, Level 16, State 1, Line 1 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s). | Journey to SQL Authority with Pinal Dave