I have been using the SQL Server Business Intelligence Development Studio to debug some stored procedures that I work with. It seems impossible to view the content of the temporary tables during debugging sessions. This fact limits the tool's usability severely for me :(
Why is it so difficult the get a confirmation of this limitation searching the internet??
Now I made the temporary tables permanent (removed the #) and manually drop them after each debugging session.