查询 SQL 存储过程 的修改记录

 

        SELECT  [name] ,
                create_date ,
                modify_date
        FROM    sys.all_objects
        WHERE   type_desc = N'SQL_STORED_PROCEDURE'
        ORDER BY modify_date DESC