Tool to chase down the consequences of adding field to DB tables?

Hi all,

I'm tasked with adding a few fields to our database, and all of the
stuff that goes along with it (updating c# UI code, etc.). The
database is a few hundred tables, with all of the procs, logic code,
etc. that goes along with it.

The consequences (i.e. what breaks) of adding a new field should be
largely predictable from the current structure, along with the fields
to be added. Anybody know of a tool that will tell me this? Or do I
need to just ctrl-f (search) my way through the table names, and do
this manually?

Thanks for any bright ideas,

cdj