title: SQL server schema and default schema
body: <p>I have a schema define in my database. Except now everytime I do a sql statement I have to provide the schema ... 
  <code>SELECT * FROM [myschema].table</code></p>
  
  <p>I set the default schema for my user using management studio and also ran the 
  <code>ALTER USER myUser WITH DEFAULT_SCHEMA [myschema]</code> 
  and I still get the invalid object 'table' when writing a query without the schema (SELECT * FROM table)</p>
  
  <p>Is there a way to write <code>SELECT * FROM table</code> without having to specify the schema name all the time?</p>
  
  <p>It's on SQL 2005 using SQL Management Studio.</p>