Table Column depends Object

SQL query that findout objects (Stored Procedure,View,Function,Trigger) used given Table Column on a database.


SELECT Name
FROM syscomments c
JOIN sysobjects o ON c.id = o.id
WHERE TEXT LIKE '%TableName%' AND TEXT LIKE '%ColumnName%'