I have two SQL SERVER 2012 banks installed on server A and server B, I need to insert and then do a Update on the server table B via linkedServer by server A, but in these tables have XML fields, I am not necessarily updating this field, but every time I try to make any updates in the other fields it returns me to msg:
"Msg 9514, Level 16, State 1, Line 1. Xml data type is not supported in distributed queries"
Someone would have some solution / example that I can use via LinkedServer or even one that I can work with on two servers with SQL SERVER 2012?