Skip to Content
0

optimize temp table resolution causing errors

Dec 08, 2016 at 11:48 AM

72

avatar image

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