This script will allow you to find all instances of a column name, or partial column name, in all user tables in the database in which it is run.  This is sometimes helpful during upgrades, etc.  There is no error checking in this script.  You can modify it to add, if needed.

Run this by simply executing the SP with the column name, or partial, you want to find.

Example:  EXEC Find_Columns 'name'

This example will return all column names in all user tables that have the string "name" in them.