Skip to Content
avatar image
Former Member

optimize temp table resolution causing errors

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers