If we need to know when the SQL objects is modified then we can use the below query to find the objects details.

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'-- give the type as required