title: Is there a way to get a list of all current temporary tables in SQL Server?
body: <p>I realize that temporary tables are session/connection bound and not visible or accessible out of the session/connection.</p>
  
  <p>I have a long running stored procedure that creates temporary tables at various stages.</p>
  
  <p>Is there a way I can see the list of current temporary tables?
  What privileges do I need to be able to do so?</p>
  
  <p>Alternatively,</p>
  
  <p>Is there a way I can see the particular SQL statement being executed inside a running stored procedure? The procedure is running as a scheduled job in SQL Server.</p>
  
  <p>I am using SQL Server 2000.</p>
  
  <p>Thanks for your guidance. </p>