Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Update table with XML column via linked server
1 view
Skip to first unread message
yc...@yahoo.com
Jan 23, 2008, 11:36:02 AM1/23/08
to
Hi. There is limitation of xml support from SQL server 2005. Xml data
type is not supported in distributed queries. So the workaround is to
use openquery. But is there a workaround to insert/update the table
with XML through linked server? Or this is not possible in sql server
2005? Thanks,
type is not supported in distributed queries. So the workaround is to
use openquery. But is there a workaround to insert/update the table
with XML through linked server? Or this is not possible in sql server
2005? Thanks,
George
Joe Fawcett
Jan 24, 2008, 3:57:50 AM1/24/08
to
<yc...@yahoo.com> wrote in message
news:86cbc11b-aae4-4679...@i72g2000hsd.googlegroups.com...
The other thing I have done is to cast the XML to nvarchar(max) before
bringing it across. Whether your XML can stand this cast depends on a number
of factors.
--
Joe Fawcett (MVP - XML)
http://joe.fawcett.name
0 new messages