title: How do I inspect table variables and temporary tables from within a debugging session in SSMS 2008?
body: <p>I'm stepping through a stored procedure in SQL Server Management Studio 2008 (SSMS). The code creates some table variables as well as temporary # tables that I would like to inspect as I go along. Now the other local variables I can see in the "Locals" window and while the table variables are listed there, I can't see their contents. I would also like to inspect the # temp tables but again any select statement that I want to run against them will need to come from the same session as the code that I'm stepping through.</p>
  
  <p>Is this possible in the SSMS 2008 debugger?</p>