Skip to Content

optimize temp table resolution causing errors

Dec 08, 2016 at 11:48 AM


avatar image
Former Member

We tried to reduce compilations of procs by turning on"optimize temp table resolution" (set to 1), but then hit a few errors with "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization."

Setting this to 0 again and it all worked again.

Any idea what causes this ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers