title: Can't find table object name
body: <p>I have an application in classic ASP, and a database in SQL server 2005.</p>
  
  <p>I transfer the database in SQL server express edition and I have one strange problem, I can see the tables in the database in this way:</p>
  
  <p>information_Schema.dbo.test, so when I execute SQL command</p>
  
  <pre><code>select * From test
  </code></pre>
  
  <p>I get error that it can't find the table.</p>
  
  <p>When I execute</p>
  
  <pre><code>select * From information_Schema.dbo.test
  </code></pre>
  
  <p>I do get results.</p>
  
  <p>The problem is that my application is many many files and I can't rewrite the SQL commands.</p>
  
  <p>Is there any way to find a solution in SQL without changing anything in my application?</p>