title: Is there any size limit for the values returned from a Stored Procedure in SQL 2005?
body: <p>I am trying to return Xml value from SQL Server 2005 using For Xml. Is there any limit in the size of xml returned from SQL Server?</p>
  
  <p>I will be using ExecuteXmlReader to get the value in my C# code. </p>
  
  <p>Also, is there any limit on the data that can hold in an XmlReader?</p>
  
  <p>Any thoughts...</p>