You use sp_depends 'ObjectName'. This will get you all dependancies

If you wish to tailor the output to your specific needs place it in a (temporary) table.

Mind, there are other ways to find dependencies, not all dependencies can be found like above. Have a read:

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