Searching Column Name in All Tables

http://www.sqlservercentral.com/scripts/68998/

*********************************************
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%ColumnName%'


*********************************************