title: View Temporary Table Created from Stored Procedure
body: <p>I have a stored procedure in SQL 2005. The Stored Procedure is actually creating temporary tables in the beginning of SP and deleting it in the end. I am now debugging the SP in VS 2005. In between the SP i would want to know the contents into the temporary table. Can anybody help in in viewing the contents of the temporary table at run time.</p>
  
  <p>Thanks 
  Vinod T</p>