Using below T-SQL Script we can get the name of Stored Procedures and Text of the Stored Procedures where how many procedures are containing the particular column name like as 'Name'
SELECT o.Name Stored_Procedure_Name, s.TEXT Stored_Procedure_Text
FROM sys.syscomments s
INNER JOIN sys.objects o
ON s.Id = o.OBJECT_ID
WHERE s.TEXT LIKE '%' + 'name' + '%'
AND TYPE = 'P'
-- Here 'Name' is Column name which is used in Stored Procedure.