An XML column has been added to to a table I frequently query using SSMS and I am now receiving the message below. This happens when I SELECT * or just select the non-xml fields. What is the workaround? I am running SQL Server 2005, but connecting via SSMS 2008.
Msg 9514, Level 16, State 1, Line 1
Xml data type is not supported in distributed queries. Remote object 'Server.Database.dbo.Table' has xml column(s).