Procedure Tuning: Query execution failed: Invalid object name '#pending_labs'
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?