SET @TABLENAME='' --Pass the Table Name here
SELECT @TableName as "Table Name",A.Name AS "SP Name",B.Text as "SP Text" from SYSOBJECTS A
INNER JOIN SYSCOMMENTS B
ON A.ID=B.ID
WHERE B.TEXT LIKE '%'+@TableName+'%'
and A.TYPE='P'
Same way we can use the above query to find out View, Trigger. If you wanted to list views and Triggers change the value of "Type" as below,
TYPE='V' --For View
TYPE='TR' -- Trigger
TYPE='V' --For View
TYPE='TR' -- Trigger