title: SQL Management Studio 'View Dependencies' Not Listing All Dependencies
body: <p>In the past I thought when right-clicking on a table in SSMS and click 'View Dependencies' it will list out all tables and stored procs that uses the table. But recently I noticed it miss some dependencies.</p>
  
  <p>Sometimes it misses some stored procs that reference it using SELECT statements, sometimes it's INSERT or UPDATE statements. There doesn't seem to be a common pattern on what is dependent and what is not. Can any one shed some light on this? (And no, it's not a permission issue. I have sysadmin rights.)</p>
  
  <p>My final goal is to find a way to find all dependencies on a particular table/view/stored proc using the simplest way (ie. little or no scripting) but it must return ALL dependencies, not just some. Any help?</p>
  
  <p>PS. I'm using SQL Server 2005 and SSMS 2005.</p>
  
  <p>Thanks.</p>