title: size limit for XML datatype in SQL 2005
body: <p>Is there a size limit on the XML data type in SQL 2005?</p>
  
  <p>When I try to return anything more than 44kb size of the XML string from my stored proc, it just returns an empty string. I am using FOR XML PATH to return hierarchical data sets in XML format from my stored procs.</p>