Question

"Xml data type is not supported in distributed queries" - How to resolve?

Answer

While you performing fetch operation using remote objects with linked server when it having XML column, it raise above such error "Xml data type is not supported in distributed queries"

SELECT * FROM Server1.Database1.dbo.Table1 WHERE Column1 NOT IN (SELECT Column1 FROM Server2.Database2.dbo.Table1) GO

But you can perform fetch for such issue,

SELECT * FROM Server1.Database1.dbo.Table1 WHERE Column1 NOT IN ( SELECT * FROM OPENQUERY(Server2,' SELECT Column1 FROM Database2.dbo.Table1' ) linked )

Read More..   [333 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  ·