Execution plan erro

• S-322532

  SSCommitted

  Points: 1613

  More actions

  February 21, 2008 at 3:05 am

  #93153

  Hi,

  I recently developed a stored procedure and tried to look at the execution plan. The procedure user temp tables and when i tried hitting on the execution plan button an error was thrown back stating as 'Invalid object name #temp_Tariffs'.

  How to avoid this error.

• Grant Fritchey

  SSC Guru

  Points: 399016

  More actions

  February 21, 2008 at 6:52 am

  #780635

  You're trying to generate an estimated execution plan. You can't with the temp tables. Generate an actual execution plan instead, which means running the query, so make sure you're not in production.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning