title: Invalid Object Name in mssql 2005
body: <p>We currently have an issue with our MSSQL 2005 database. We've recently undergone a migration from windows server 2003 to 2008. SQL Server has remained as 2005. I'm using SQL Server Management Studio to work on.</p>
  
  <p>All the tables in the database follow the format: [SCHEMA].[TABLE_NAME]</p>
  
  <p>When I enter the SQL:</p>
  
  <pre><code>SELECT * FROM [table_name]
  </code></pre>
  
  <p>I get the error message: Invalid object name '[table_name]'.</p>
  
  <p>If I type in:</p>
  
  <pre><code>SELECT * FROM [schema].[table_name]
  </code></pre>
  
  <p>This works fine. The username we log into the database with owns the schema which is prepended to all the table names.</p>
  
  <p>The problem is, we have 3rd party companies which have software which exports data from the database. 2 companies have now tried to run their exporters, however are getting the error 'Invalid object name'. The software is logging in with the username which owns the schema.</p>
  
  <p>My question is exactly the same as this one I've found on the internet:
  <a href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99802" rel="nofollow">http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99802</a></p>
  
  <p>However the answer on that question seems to be full of keywords rather than actual sentences which makes it very hard to understand.</p>
  
  <p>If anyone could help, it'd be greatly appreciated.</p>
  
  <p>Many thanks</p>
  
  <p>Phil</p>