Finding Database Object Dependencies

select *, object_name(id) as id_name, object_name(depid) as depid_name from sys.sysdepends

http://www.databasejournal.com/features/mssql/article.php/3571026/Finding-Database-Object-Dependencies.htm

http://www.mssqltips.com/tip.asp?tip=1294

sp_depends:

http://msdn.microsoft.com/en-us/library/ms189487.aspx

sys.sysdepends:

http://msdn.microsoft.com/en-us/library/ms190325.aspx

sys.sql_dependencies:

http://msdn.microsoft.com/en-us/library/ms174402.aspx

sys.sql_expression_dependencies:

http://msdn.microsoft.com/en-us/library/bb677315.aspx