Recently while working with data migration,got an error while running a following query where Server2 has beed added as linked server.

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

-- Error raised while run above query
"Xml data type is not supported in distributed queries. Remote object 'Server2.Database2.dbo.Table1' has xml column(s)."

Server2.Database2.dbo.Table1 objects has another column named 'column2' has xml datatype and we have not used it anywhere in query. We used 'column1' of that table only and it has not xml datatype, even it has raised error. For the solution to avoid such error i have revised query as following.

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

And query ran with success. Have you received this type of error earlier? You may share here.