title: Query temp table in stored proc whilst debugging in SQL 2008 Management Studio
body: <p>I have a really large stored procedure which calls other stored procedures and applies the results into temp tables.</p>
  
  <p>I am debugging in SQL 2008 Management Studio and can use the watch window to query local parameters but how can I query a temp table on whilst debugging?</p>
  
  <p>If its not possible is there an alternative approach? I have read about using table variables instead, would it be possible to query these? If so how would I do this?</p>