Generate Data Script fails with out of memory error:
Message : Exception of type 'System.OutOfMemoryException' was thrown.
sender, DoWorkEventArgs e)
Inner Exception: System.OutOfMemoryException
Message : Exception of type 'System.OutOfMemoryException' was thrown.Generate Data Script fails with out of memory error.
A similar memory error is thrown when exporting tables via the Export Data Wizard:
Program memory is too low. 399 MBs available. Reduce size of work load or increase RAM. The application has run out of memory or disk space while exporting the results. Please limit your result set or use a more efficient export type such as CSV (Comma Separated Values).
Product defect. Toad is unable to export a table with a row size of ~32mb.
Waiting for fix in a future release of Toad for SQL Server.
The fix is included in the latest Toad for SQL Server Beta version (126.96.36.1999) - http://toadforsqlserver.com/beta.jspa. Do note that Quest Support does not provide assistance with Beta versions and any questions or inquiries should be directed to the Toad forums.