title: Search a column name across all databases
body: <p>I have this query that finds all tables and views that matches my column name of a certain database. I am using <strong>SQL SERVER 2008</strong></p>
  
  <pre><code>SELECT table_name FROM information_schema.columns
  WHERE column_name = 'product_name'
  </code></pre>
  
  <p>I want to extend the capability of my query to search across all databases and even look for Stored procedures whose having my searched column name.</p>