Find function dependencies

Produces a list of functions and the objects that use them.

Dependencies and References in SQL Server

It is important for developers and DBAs to be able to determine the interdependencies of any database object. Perhaps you need to work out what process is accessing that view you want to alter, or maybe find out whether that table-type you wish to change is being used. What are all these dependencies? How do you work out which are relevant? Phil Factor explains.

Find dependencies between field and sp/function

This script shows the stored procedures and functions affected by field name change in a table.

Fastest way to find DB object dependencies

One of the fastest ways to find out objects dependencies in SQL Server.

Identifying Object Dependencies in SQL Server

Is there a way to identify which objects are dependent on other objects within a SQL Server database? I need to modify the table structure to add new columns. However, before making any changes I want to make sure that I understand all the object dependencies. Is there a way in SQL Server 2008 to quickly identify all the object dependencies?

SQL Server 2008 views

View - Table Usage (Recursive)

Written to explore the table dependencies of a view, especially when the view queries other views.

Determine Object Dependencies Before Changing Your SQL Server Schema Design

Maintaining a database often means schema changes. Before you change or delete anything, be sure to check for dependent objects.

Tables referenced by a stored proc (2000)

This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.

Using Object Dependencies in SQL Server 2008

Previous versions of SQL Server were not that great at keeping track of object dependencies. The reason for this was due to the fact that all object dependencies were tracked by the ID of the object, which meant that the object had to exist first.