title: Can you set default Schema for SQL 2008 Query
body: <p>I have a schema called application.  Is there a way that, rather than using the syntax</p>
  
  <pre><code>SELECT * FROM application.table
  </code></pre>
  
  <p>I can set the default schema so that I can just use</p>
  
  <pre><code>SELECT * FROM table
  </code></pre>
  
  <p>It would be the same idea as a using statement I suppose.</p>