XML as an input parameter for stored procedure

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  April 10, 2008 at 9:25 am

  #379710

  Hi,

  I tried to find in B.O.L. and googled it but could not find the answer. I am going to create a stored procedure which will accept XML documeent as an input parameter. The size of this XML could be up to GBytes.

  Is there a limit for its size in SQL Server?

  Thanks

• jezemine

  SSCrazy Eights

  Points: 8059

  More actions

  April 10, 2008 at 10:06 am

  #801071

  seems like a job better suited for this:

  http://support.microsoft.com/kb/316005%5B/url%5D

  ---------------------------------------
  elsasoft.org

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 10, 2008 at 11:48 am

  #801125

  Max size of XML data type is 2 Gigabytes.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon