FIND CREATED AND LAST MODIFIED DATE OF A STORED PROCEDURE
You can find the details about these things in sys.objects table.
It is very helpful in finding when was the last time the stored procedure is modified.
Please see the example below.
SELECT NAME AS ‘Stored Procedure Name’,
WHERE TYPE = ‘P’ AND is_ms_shipped = 0 AND NAME = ‘aesp_AddLeaveBalance’
Also visit Select * from sys.objects for further details.