Get the list of stored procedures last created or modified
Get the list of stored procedures created and / or modified on a particular date?
SELECT name, create_date, modify_date FROM sys.procedures WHERE CONVERT(DATE,create_date) = CONVERT(DATE,GETDATE()-1)
1