Procedure Tuning: Query execution failed: Invalid object name '#pending_labs'

Ken@gau 2017-06-24 15:21:27

When attempting to use Plan Explorer to tune a stored procedure, I get an error:

Query execution failed: Invalid object name '#pending_labs'

The stored procedure creates and drops two temporary tables.

SSMS generates an execution plan when I run the stored procedure.

Can I use Plan Explorer to tune SQL procedures that have temp tables?

Thanks!

Aaron Bertrand 2017-06-26 17:23:53
Can you share the full definition of the stored procedure, and how you are calling the procedure from Plan Explorer?