title: SQL Server 2005 Error 701 - out of memory
body: <p>I'm currently having following error message when executing a .sql file with about 26MB on SQL Server 2005:</p>
  
  <pre><code>Msg 701, Level 17, State 123
  There is insufficient system memory to run this query.
  </code></pre>
  
  <p>I'm working with 4GB RAM, 64Bit Windows 7 Ultimate, Core2Duo T6400(2GHz)...</p>
  
  <p>Is there a way to execute it without receiving this message (maybe force SQL Server to use swap file?) or a way to execute it in parts (like 100 queries a time)...</p>
  
  <p>The file is basically a CREATE TABLE followed by thousads of INSERT queries and I have a lot of those (converted .DBF files to SQL queries using ABC DBF Converter)</p>
  
  <p>Any idea will be very appreciated!</p>