SQL Script to Find Column from all tables in a SQL Server database

I’m working with huge databases these days.  I’m new to these databases, and it is impossible for me to get familiar with every table and every column right away.   From time to time, people ask me to do some queries based on certain column.  They just tell me the approximate column name.  I need to[…]