1. In Toad for SQL Server 3.1, connect to SQL Server 2005, open an editor window.
2. Run a memory intensive query such as a query with 4 joins and produces at least 120000 rows.
3. "Browse another table"
a) Either run a select on another table in the Editor.
b) or switch to DB Browser and click on the data tab.
4. Clear the cache. Options | Database | Cache | Clear Cache.
User gets "Exception: System.OutOfMemoryException."
WORKAROUND:
None
STATUS:
Waiting for fix in future release of Toad for SQL Server.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center