In SQL server 2005, distributed query is not supported if there is xml type column in the table. I could use nvarchar in the table and create view and cast it to xml to work around it. But how could I utilize the xml schema? How to utilize XML index in such situation? Please help. Thanks a lot. George
You cannot use the XML Schema or XML index on XML data inside a nvarchar column. The recommended way to deal with doing DQ and XML is to use pass through queries. That way you can still use the XML data type on the remote database. Best regards Michael wrote in message news:fc8e1943-4a00-4f4e-a17b-eb1034b448e8@i7g2000prf.googlegroups.com... > In SQL server 2005, distributed query is not supported if there is xml > type column in the table. I could use nvarchar in the table and create > view and cast it to xml to work around it. But how could I utilize the > xml schema? How to utilize XML index in such situation? Please help. > Thanks a lot. > > George
