TheSQLGuru (1/16/2014)
Not enough time to check, but does tempdb.sys.tables show temp objects that aren't yours?
Yes
Also, does it provide a name that is "droppable"?
No, though you could probably write code that gets it right most of the time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability