title: How do I search an SQL Server database for a string?
body: <p>I know it's possible, but I don't know how.</p>
  
  <p>I need to search an SQL&nbsp;Server database for all mentions of a specific string.</p>
  
  <p>For example: I would like to search all tables, views, functions, stored procedures, ... for string "tblEmployes" (not data within the tables).</p>
  
  <p>One of the reasons I need this is I would like to remove some extra data tables that are created, but I am afraid that they are maybe used somewhere in procedures or functions.</p>