title: Does ADODB.Stream have a maximum file size it can handle?
body: <p>I'm using Microsoft SQL Server 2005, and exporting image data types to files (From a Sharepoint database), using a script not too dissimilar to the one found <a href="https://stackoverflow.com/questions/1366544/how-to-export-image-field-to-file">here</a></p>
  
  <p>It works well, but for some reason with it fails on files that are more than ~45MB:</p>
  
  <blockquote>
    <p>Msg 0, Level 11, State 0, Line 0<br>
    A severe error occurred on the current command.  The results, if any, should be discarded. </p>
    
    <p>Msg 0, Level 20, State 0, Line 0<br>
    A severe error occurred on the current command.  The results, if any, should be discarded.</p>
  </blockquote>
  
  <p>So, I've had to add the argument <code>WHERE DATALENGTH(Content)/1024 &lt;= 45000</code> so that it runs through the files it can without failing.</p>
  
  <p>Does anyone know if ADODB.Stream has a maximum file size it can handle?</p>