Here is quick query to find stored procedure related to column in database. This comes handy when you have to alter/remove a particular column from a table and you need to find all procedures referencing that column.
-- find stored procedure related to a column in database
SELECT DISTINCT objects.name, objects.type,
FROM syscomments comments
INNER JOIN sys.objects objects
WHERE comments.text LIKE '%AddressID%'