Finding out list of Stored Procedures which uses particular Table/Column....

So many times, while doing the impact analysis we need to find out the list of Stored procedures which uses a particular Table/Column.

Below query gives us the list stored procedures.

SELECT OBJECT_NAME(SC.ID),TEXT FROM SYSCOMMENTS SC

JOIN SYSOBJECTS SO ON SC.ID=SO.ID WHERE SC.TEXT LIKE '%CUSTID%'

AND SO.TYPE='P'