title: Find reference to (misspelt) object in sql server stored procs
body: <p>I know that in a sql database stored proc, there is a misspelt (therefore non existant)sq object. What would be the best way to search the body of every stored proc in the database for this string?</p>
  
  <p>This would be the equivalent of find all references in visual studio so very useful.</p>
  
  <p>Server is sql server 2005.</p>
  
  <p>Many Thanks</p>