Now what tables have columns with that name?

This is a great script by Don Hite that will list the tables in your DB that have a particular name. (Not that I have a need to do that.)