title: sql server 2008 - find which tables contain specific text
body: <p>i have a database that has a few hundred tables</p>
  
  <p>i need to find a specific string in any of the columns in all of the tables.</p>
  
  <p>how would i approach this problem>??</p>