Findout the recently modified objects in sql database

SELECT name, create_date, modify_date

FROM sys.objects

WHERE type = 'P'

order by modify_date desc

Find a string in all Stored Procedures

Find a string in all Stored Procedures:

SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE '%foobar%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1
GROUP BY OBJECT_NAME(id)