Distributed queries with XML

• okbangas

  SSChampion

  Points: 11773

  More actions

  June 11, 2012 at 2:31 am

  #259230

  Is distributed queries with xml (data type) supported in SQL Server 2012? It is neither in 2005 nor 2008, which I find a bit annoying.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]

• oconnor_dp

  SSC Journeyman

  Points: 93

  More actions

  August 28, 2012 at 6:56 pm

  #1531171

  Nope. Think about it, the xml datatype can be up to 2GB. You want to pass that around? Don't!

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  August 29, 2012 at 10:48 am

  #1531518

  oconnor_dp (8/28/2012)

  ---

  Nope. Think about it, the xml datatype can be up to 2GB. You want to pass that around? Don't!

  The issue it not necessarily in returning the XML column:

  Connect Issue > MSFT - Maddog: Can't do a distributed query into a table w/ XML columsn even if you're not referencing the XML column by moody31415

  That said, what would be wrong with returning a sensibly sized XML column in a distributed query? The MAX datatypes are already supported.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato