title: Find a string by searching all tables in SQL Server
body: <p>Is there any way to search for a string in all tables of a database in SQL Server?</p>
  <p>I want to search for string say <code>john</code>. The result should show the tables and their respective row that contain <code>john</code>.</p>