In SQL Server, how can I find everywhere a column is referenced?

Question

Within my rather large database, I would like to find out everywhere a column is referenced within the entire schema (SPs, functions, tables, triggers...). I don't want to just do a text search since this will pick up comments and also will find similarly named columns from other tables.

Does anyone know if/how I can do this? I use Sql Server 2008.

Answer 1

Check here:

http://stackoverflow.com/questions/686247/how-to-find-the-list-of-stored-procedures-which-affect-a-particular-column

Answer 2

This answer also discusses using sys.sql_dependencies. You may also need to use sp_refreshsqlmodule as I mention here