I have Toad for SQL Server 5.5 and I am get “Out of memory.” errors frequently.
I have reset my Application Data Directory which is commonly suggested as a workaround.
However, eventually, the problem will resurface after time.
Below are sample actions I am doing:
1. Connect to a server/DB
2. Open a file containing SP source
3. Open an editor tab for executing the SP (there is no result set returned from this SP)
4. Edit the SP/compile… edit/compile… edit/compile… save
5. Execute the SP in the second editor tab
6. Repeat steps 4 and 5