title: SQL Server 2008: find all tables containing columns with specified name
body: <p>I know it is possible to select the tables which contain a specific column name with a query like:</p>
  
  <pre><code>SELECT t.name,
         c.name 
  FROM sys.tables t 
  INNER JOIN sys.columns c 
     ON c.object_id=t.object_id 
  WHERE c.name like '%colname%'
  </code></pre>
  
  <p>Is there a way to find the tables which contain 2 or more given columns?</p>
  
  <p>To give an example, what I want to find is all tables that have the specific columns: student and teacher.</p>