Find out Stored Procedure, Views, Functions, Triggers related to a Table

SELECT DISTINCT A.name, A.xtype 
FROM syscomments B
INNER JOIN sysobjects A ON B.id=A.id
WHERE B.TEXT LIKE '%Employee%'

This will show all SP, Views, Functions, Triggers  related to Employee Table.