title: How we find the database instance name from procedure in sql
body: <p>My question is: if I write a store procedure like this:</p>
  
  <pre><code>create procedure test
  as
  begin
      select * from databasename..Tablename 
  end
  
  create procedure test1
  as
  begin
      select * from databasename..Tablename 
  end
  </code></pre>
  
  <p>Then how to find the <code>databasename..</code> from above both procedure? I need a query to find the list of procedure name who used like <code>Databasename..tablename</code>. inside the procedure stuff</p>