I'm sure this question has been asked before, so at the risk of being flamed
mercilessly I'm going to ask it again.
SQL Server 6.5's "showplan" accommodated temporary tables nicely, even when
used in conjuntion with "noexec." This capability proved invaluable in
debugging and tuning ill-behaved SQL, including scripts which took advantage
of Transact-SQL's ability to create and manage temporary tables.
With 7.0, this appears to have gone away. "Showplan" and "noexec" have been
effectively combined into "showplan_text" (or "showplan_all") which on their
surface appear to be a functional equivalent. They're not. Unlike in 6.5,
temporary tables which are created as part of the SQL being analyzed are not
actually created. Subsequent referenced to said tables then fail with a
"table does not exist" message.
Is there a work-around to this? Is there something I'm missing? Has MS
addressed this at all in this forum or on their Web site?
Any guidance would be greatly appreciated.