This code is something I used frequently, when I started to work with an old legacy database, with more, than 400 tables.

SELECT		
	c.name  AS 'ColumnName'
	,t.name AS 'TableName'
FROM		
	sys.columns c
INNER JOIN	
	sys.tables  t   
	ON 
		c.object_id = t.object_id
WHERE		
	c.name LIKE '%Column Name%'
ORDER BY	
	TableName, ColumnName