How can I find out what database dependencies there are with tables, views, and stored procedures?
You can run the following command line:
sp_depends %Database Object Name%
The database object name is the name of a table, view, stored procedure, or function.
The attached file is a SQL query that can run through a database and return all the dependencies in a table. There are four possible displays mode (just change the @DisplayChoice value) of this SQL script.