Check a column used in which Store Procedure in SQL

 To know Check a column used in which Store Procedure in SQL run the following script:

SELECT DISTINCT Name
FROM sys.
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Table_Name%'
AND OBJECT_DEFINITION(OBJECT_ID) LIKE '%Column_Name%';