Update table with XML field and on different banks

2

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?     

asked by anonymous 07.12.2017 / 16:23

0 answers