title: Stored procedure scope: using sp from another database
body: <p>I hava a stored procedure named PROC_fetchTableInfo (simple select from sys.tables) in a database named</p>
  
  <pre><code>Cust
  </code></pre>
  
  <p>I would like use this procedure in a another database named</p>
  
  <pre><code>Dept
  </code></pre>
  
  <p>I tried to execute this sp in this database using command</p>
  
  <pre><code>EXECUTE Cust.dbo.PROC_fetchTableInfo
  </code></pre>
  
  <p>but as a result I get tables from the database Cust. How to get this procedure to work in database Dept?</p>