Last modify date of a Database

SELECT name, create_date, modify_date


FROM sys.objects

WHERE type = 'P' ---------P=Procedure name---------

AND name = 'DatabaseName'