如何在SQL Server中快速识别最近修改的存储过程

SELECT TOP 10
    o.name AS ObjectName,
    o.type_desc AS ObjectType,
    sm.definition AS Definition,
    o.modify_date AS LastModifiedDate
FROM
    sys.objects o
INNER JOIN
    sys.sql_modules sm ON o.object_id = sm.object_id
WHERE
    o.type IN ('P', 'FN', 'IF', 'TF')
ORDER BY
    o.modify_date DESC;