title: Table without lock won't query unless nolock hint included
body: <p>Microsoft SQL Server 2008 R2</p>
  
  <p>I have a table that currently can not be queried on but seems to not have a lock against it.</p>
  
  <p>Doesn't return:</p>
  
  <pre><code>SELECT * FROM myTable
  </code></pre>
  
  <p>Does return:</p>
  
  <pre><code>SELECT * FROM myTable with (nolock)
  </code></pre>
  
  <p>Inserts into the table also fail.</p>
  
  <p>When I run <code>sp_lock</code>, I don't find any instances of locks on <code>myTable</code>. When I run the "Resource Locking Statistics by Object" report, I don't see any locks for <code>myTable</code>.</p>
  
  <p>What other possibilities could there be that would keep a table from being acted upon?</p>
  
  <p>Thanks.</p>