Turn Off Schema Collection
I'd like to enable schema collection when I'm writing code, and disable it when I'm doing adhoc queries. Why: We have 100 identical databases with 1900 tables in each database. When I run a query that pulls data from each database sqlprompt starts collecting schema data from all 100 databases, then it runs out of memory and crashes.
The "Turn Off Prompting" option does not help.
example:
select id,customer from DB1.dbo.orders where date > @d
union select id,customer from DB2.dbo.orders where date > @d
...etc...
4
votes
jon mcghee
shared this idea
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/