title: Can't find object in tempdb
body: <p>I'm using SQL Search by redgate to search for a key word and some of my results look like this:</p>
  
  <pre><code>Database |  Schema |  Object name  | Type ...
  tempdb   |  dbo    |  #6FBF826D    | User table ...
  </code></pre>
  
  <p>How do I find out what this refers to? I had a look in tempdb.sys.all_objects but an object with name '#6FBF826D' isn't in there (although there are others with similar names). Am I looking in the wrong place?</p>
  
  <p>For that matter, what is meant by 'user table' in this context? I didn't create any tables with names like that.</p>