title: How to write SQL script to find rows in any tables of a SQL Server database that have a string column which value is equal to a keyword?
body: <p>Environment: Windows, SQL Server 2008</p>
  
  <p>For example, my database has Table1, Table2, Table3... TableN, each table has Column1, Column2, Column3...ColumnN. Simply, they're all string column.</p>
  
  <p>I want to find rows, no matter from which table, which have a column's value is 'Key' no matter which column.</p>
  
  <p>How to write a script to do that?</p>
  
  <p>Thanks!</p>