title: Setting/changing current database schema in the Trasact-SQL statement
body: <p>SQL allows easy setting/changing current database with <code>use xxx_db;</code> 
  statement but it looks like it does not allow changing the current schema. There is similar question for Postgres, I see on the internet this for ORACLE:</p>
  
  <pre><code>ALTER SESSION SET CURRENT_SCHEMA = joe;
  </code></pre>
  
  <p>What about MS SQL Server?</p>
  
  <p>AFAIK, the default schema is set in the properties of the user. This means that queries (or stored procedures) that are intended to be run by different users should specify the schema explicitly (who knows what is the setting of the user plus SQL code will get broken if somebody will change the user setting).</p>
  
  <p>Maybe somebody knows the rationale why this is not important? Is it really true that typical SQL code is strongly tied to the setting of the user?</p>
  
  <p>Can it be that using schemas for anything different from organizing security is not recommended?</p>