Find Stored Procedure based on column name of a Table using Like search in SQL Server

Please refer below query to all procedures based on Column name and Table name.

SQL

SELECT OBJECT_NAME(M.object_id), M.*
FROM sys.sql_modules M
JOIN sys.procedures P
ON M.object_id = P.object_id
WHERE M.definition LIKE '%Fax%' -- Column Name
AND OBJECT_DEFINITION(P.OBJECT_ID) LIKE '%' + 'Customers' + '%' -- TableName

I hope this will help you out.