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."
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center