title: Stored procedure dependencies in SQL Server Management Studio
body: <p>I don't know much about the MS world, but now it happens to be that I have to use SQL Server Management Studio 2008.</p>
  
  <p>My problem: I have a column in a table, and I need to see all the stored procedures that may be acting on it.</p>
  
  <p>I tried right-clicking and going 'View Dependencies' but that doesn't seem to be returning everything that it should be.</p>
  
  <p>Questions like this one: <a href="https://stackoverflow.com/questions/299128/sql-server-dependencies">SQL Server Dependencies</a> have answers that offer 3 types of solutions</p>
  
  <ol>
  <li>Paid third party tools.</li>
  <li>Writing your own scripts.</li>
  <li>Exporting everything into text files and grepping them.</li>
  </ol>
  
  <p>WTF? Am I missing something obvious? Is that actually how things work? I would imagine that this is a very common use case: you want to alter table and you want to make sure you won't break anything. Or if say you're looking at a new project with a DB for the first time and you want to see how certain columns get populated with stored procedures. Is there actually no quick and easy built-in workflow to do this?</p>