title: Find all references to an object in an SQL Server database
body: <p>I'm trying to find all references to an object in an SQL Server database.</p>
  
  <p>How can I quickly search? SQL Server Management Studio does not seem to do it. I use <a href="http://www.red-gate.com/products/SQL_Search/" rel="noreferrer">http://www.red-gate.com/products/SQL_Search/</a> but I'd like to find the "official" Microsoft solution to this. Is it in another product?</p>
  
  <p>For example, when I do a mass search in visual studio, I would like to be able to also find something in all stored procedures.</p>
  
  <p>Or maybe I'm not coding this the right way?</p>
  
  <p>Carl</p>