Find Column Used in Stored Procedure –

 Solution:

Syntax:

SELECT obj.Name as SPName, sc.TEXT as  SPTextFROM sys.syscomments scINNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_IDWHERE sc.TEXT LIKE '%' + 'Name Your Column Here' + '%'AND TYPE = 'P'

Implementation:

Suppose your column name is "Year"

SELECT obj.Name as SPName, sc.TEXT as SPText
FROM sys.syscomments sc
INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID
WHERE sc.TEXT LIKE '%' + 'Year' + '%'
AND TYPE = 'P'