shank wrote:

> I'm using that statement to generate the XML code. I'm trying to generate 
> that code then pass to our users out of convenience for them. However, the 
> size of the generated code is HUGE and I'm having problems making it a 
> convenient download. Once I get it into a database field, it's so large that 
> browsers timeout trying to access it.

Not sure how you do it but "get it into a database field" sounds 
strange, you should use the ExecuteXmlReader method of an SqlCommand 
object (with e.g. SELECT col1, col2, ..., col2 FROM table FOR XML AUTO, 
ROOT), then if you want to pass on that XML within an ASP.NET page to a 
browser you should do e.g.
   using (XmlReader xmlReader = sqlCommandInstance.ExecuteXmlReader())
   {
     Response.ContentType = "application/xml";
     using (XmlWriter xmlWriter = XmlWriter.Create(Response.Output))
     {
       xmlWriter.WriteNode(xmlReader, false);
     }
   }
That way the XML should be streamed from SQL Server to ASP.NET and from 
ASP.NET to the browser. Might need to turn off ASP.NET output buffering.


-- 

	Martin Honnen --- MVP XML
	http://JavaScript.FAQTs.com/