title: Invalid object name
body: <p>When doing...</p>
  
  <pre><code>select * from students
  </code></pre>
  
  <p>I get a "Invalid object name" error.  Basically, I think I can see the problem in that the tables are prefixed with an object name rather than just dbo, lets call the schema "test".</p>
  
  <p>So this means....</p>
  
  <pre><code>select * from test.students
  </code></pre>
  
  <p>The problem I have is that I can't change the SQL code (it's in release, long story) or change the tables.  My question is, is there anything I can change in SQL server that will allow me to connect say with a specific SQL server user so I can still run my queries as...</p>
  
  <pre><code>select * from students
  </code></pre>
  
  <p>Omitting the object name, but still have the object name against the table?  I can add another SQL user or something like that no problem.</p>
  
  <p>I'm using Java over the jdbc protocol, so my connection string is something like jdbc:sqlserver://hostname:port;databaseName=db;user=myuser;password=mypassword</p>
  
  <p>Thanks,</p>
  
  <p>David</p>