Temp tables on the current connection
===

if I do:

    select * from tempdb.sys.tables

I will see all the temporary tables in the system, however that view does not have information about which connection/user each table belongs to.  I'm interested in finding only the tables I've created on my current connection.  Is there a way to do this?

thanks - e

p.s. yes, I could try reading each table listed with the notion that those that succeed should prove to be mine (on recent versions one can't read other connections' tables) but that is too costly an approach since there may be thousands of tables on the system

p.p.s. I did read http://stackoverflow.com/questions/7075483/is-there-a-way-to-get-a-list-of-all-current-temporary-tables-in-sql-server which asks the right question but did not get a good answer