sql查询存储过程的修改记录和时间

 

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