I'm sure this problem could be solved by documenting things better but...
We've had problems where we changed what a user-defined field was used for or the range of allowed values for a field and we forgot about someplace we were using that field (view, SP, etc.) that would break due to the change.
I'm looking for a way to search through all views, stored procedures, triggers, functions, etc in a given table for use of a particular field. Searching the field name would suffice, but searching for a field from a particular table would be better.